D
Dannette
I have a report that is based on a query that has two
tables. The "Request Number" field in both tables are
joined. The Join Type is 2. When I first run the report,
it runs fine. I can run many times OK. As soon as a make a
change in the report and save the query switches the JOIN
to a different field in that same table. Then when I try
to run the report, I get the type mismatch since it change
the JOIN to a field with different properties. ANY IDEAS?
tables. The "Request Number" field in both tables are
joined. The Join Type is 2. When I first run the report,
it runs fine. I can run many times OK. As soon as a make a
change in the report and save the query switches the JOIN
to a different field in that same table. Then when I try
to run the report, I get the type mismatch since it change
the JOIN to a field with different properties. ANY IDEAS?