Based on your response, I determined that I was not working in the right place. I was in the screen for "Dummies" and the Expr and ( ) were inserted by Access each time I finished the statement. I looked harder and got into the SQL view and now should be able to to use some of your...
This sounds like it should give me what I want, but I ran into a complication. The Inv Amt Tbl (actually a query) I have extracted data so each item is only listed once. In the Cust Inv table, an item may be listed more than once, but the basic data I am extracting will always be the same for...
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...
Thanks for your comment. I have been able to get the column set as both number and text. Number setting won't read text and text setting won't read numbers.
Subsequent to my message, I found documentation on Microsoft website that Access determines col type by first 8 items in the column...
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...
Thanks, I will give this a try. I'm a novice so will ask for some clarification: Month01, Month02, etc are field names for the monthly columns? Your suggested criteria would go into each of those columns? Why does the "if" statement use "iif"?
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.