Hi There,
I have three crosstab queries that display different information for time sheets. The problem that I have is when I put the three queries together, it makes 5 or more duplicate copies of all the records. One of the fields is a date field that I need to pick dates from. I have made all the fields the same. But it doesn't matter.
PLEASE HELP
Also, when I try and use Between [] And [] to pick a date, it says that it doesn't reconize the field - Any suggestions?
Jen
[This message has been edited by Jade (edited 02-03-2002).]
I have three crosstab queries that display different information for time sheets. The problem that I have is when I put the three queries together, it makes 5 or more duplicate copies of all the records. One of the fields is a date field that I need to pick dates from. I have made all the fields the same. But it doesn't matter.
PLEASE HELP
Also, when I try and use Between [] And [] to pick a date, it says that it doesn't reconize the field - Any suggestions?
Jen
[This message has been edited by Jade (edited 02-03-2002).]