Macro erros running query with date prompt

  • Thread starter Thread starter Charlie
  • Start date Start date
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
 
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).
 
Back
Top