It worked! it was on the SQL code. Thank you so much for your help.
Do you think I should redo the entire form by doing what you said about the query? I do have Table Relationships within the database. Is that incorrect?
You can probably "cheat" a bit, and take the SQL code that you have to build you query, and you can go in there and clean it up a bit (make any necessary changes).
And then make that the Control Source of your query.
Now, going forward, you can use the query for maintenance purposes (i.e. if you have to add calculations or criteria on the future).
Thank you so much! I'll do thatYou can probably "cheat" a bit, and take the SQL code that you have to build you query, and you can go in there and clean it up a bit (make any necessary changes).
And then make that the Control Source of your query.
Now, going forward, you can use the query for maintenance purposes (i.e. if you have to add calculations or criteria on the future).
You are welcome!