I recently migrated an Access 97 database to Access 2003. After figuring out how to get rid of the GUIDs & other such system generated fields, my database is clean now. But some of the queries are not performing correctly. I am using left join on two queries to generate a third. Query 2 has a subset of the records derived based on a Yes/No field. So, when I run the query I get #error values for all records which do not exist in query 2.
Query 2 has Dynamic Loadsize as Yes/No & Dynamic UPH which is a calculated field.
The current query gives #Error for dynamic UPH when Dynami Loadsize is No.
Query 2 has Dynamic Loadsize as Yes/No & Dynamic UPH which is a calculated field.
The current query gives #Error for dynamic UPH when Dynami Loadsize is No.