Hi, i have found that access had not frozen, it was just taking ages to run. and it came up with results. but multiple results. i am assunming this is due to the "union" statement. Do i need to use this? can i not just run the query without the union, but pull both fields i require into the ms query, then select the correct one using the iif?
SQL problem within Access
- Thread starter kella101
- Start date