Macro erros running query with date prompt

C

Charlie

I have an mdb with linked sql server 2000 tables, have a simple query with
two tables that prompt for a beginning date and an ending date. The query
runs fine if run directly. However, if I put it in a macro and try to run it
I get an error telling me that the Date can exist in more then one table. It
only exist in one of the two table being used. I have tried adding the table
name prefix to the filed, but am still getting the same error.

I really, really need to run this query from the macro. Does anyone have a
clue what is going on???

Thanks
Charlie
 
S

Steve Schapel

Charlie,

Did you name the field 'Date'. This is a Reserved Word (i.e. has a
special meaning) in Access, and should not be used as the name of a
field or control. Not saying this is the problem, but it could be.

Other than that, you will need to give the specific details of the macro
(tell us what Actions you are using) and the query (post the SQL view here).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export table to txt file with a variable filename 0
Compact & Repair, Open table, close table, then run macro 3
Run a macro and pause before running second macro 1
Macro conditions to open a query 2
Macro fails from button, runs when selected directly 5
How to filter report using macro based on selected option from query 0
A Report, based on query, called from macro is prompting for param 1
Repeat macro until record count of query = 0 0

Top