Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: rlp
  • Content: Threads
  • Order by date
  1. rlp

    Select data based on common fields

    I have two tables with a common field: Tbl Inv Amt Inv_No Inv_Amt Tbl Cust Inv_No Cust_No Cust_State How do I create a query to give me Inv_No, Cust_No, Cust_State, Inv_Amt. I thought I could join the tables and just pull in those fields into one query from the two tables but it lists each...
  2. rlp

    Number as text

    I am linking an Excel sheet to Access 2000. I have two fields that should be treated as Text and are defined as Text in Excel. Both contain some items that are alpha-numerical and some that are all numerical. The link sets up both fields as Text, but items that are all numerical are being...
  3. rlp

    column by date

    My table includes "Amount" and "Month" fields (1,2,3, etc). I want the amounts to appear in columns by month. Have tried to create columns for Amount with criteria of Month = 1, Month = 2, but it doesn't work. Have tried (SELECT) statements but can't seem to put together...

Part and Inventory Search

Back
Top