Recent content by cMcDowell23

I solved my issue! I think it was an issue with my INNER JOIN. I changed it to LEFT JOIN and we were good! Thanks for all your help!

Back story: In my database I have created a query that pulls jobs based on the status (In Progress, Invoiced, Completed, etc.) and then a 2nd query to further refine it by the location of the job (Downtown, In Town and ITBNDT & OOT [In town but not downtown & out of town]). It is taking the...

Darn! Is that maybe my issue? That I am using a late version of Access? or would that help me maybe?

Okay I think I have compacted my database properly. How to Use: ON Main Menu Form - Click Purchase Order Entry Form Button That will open Work Entry Form which is the form that is not pulling my data from "Work Entry Summary Query" NOTE: My back, next and other little buttons don't work yet...

Yes I have test data to see if my queries are pulling the correct information.

Thank you! I fixed why my Query was uneditable, but now my form isn't pulling any information form this Query. :(

I have a Query and a form that uses this Query for a Purchase Order database for our company. We had this same database created for us a long time ago and throughout the years there has been changes we made that has now rendered the old database unusable. Now I am recreating the database based...