Reply to thread

Message: [QUOTE="Uncle Pete, post: 1923622"] Trying to use a table value as a variable in a simple query. Access 2000 running on Win98SE. (Disclaimer: I apologize if this is something exceptionally easy that even a moron should know how to do or if it’s in the book [I should RTFM]) Here’s the situation: Table 1 is a name /address list called “Sales”. Each entry has standard name and address data and a “Terminal ID” field, which is unique and the index. Table 2, “Transactions” has the Terminal ID, transactions and a numeric field called “Month” (i.e. 7 for July, 8 for August, etc.). Table 3 is called “Current Month” and has a single numeric entry (i.e. 7 for July, 8 for August, etc.). I’m trying to make a select query in design view* that will join the name and address data and the transactions only for the month listed in current month. I tried using [Tbl Transactions]![Month] equal to [Tbl Current Month]![Current Month] as criteria, but the query returns all transactions regardless of the value in the Month field of the Transactions table. * I’ll try to work w/SQL if I have to but I’d rather not (I’m a hardware guy). Thanks in Advance Uncle Pete [/QUOTE]