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
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