Search results

I have attached a screen shot of my database schema. This is my scenario; There are 3 different situations when it comes to searching a quote. 1. You have a job with 0 quotes. 2. You have a job with say 3 quotes, but none have been awarded. 3. You have a job with 3 Quotes, 1 or 2 have been...

I've been staring at this for a while and have had no luck, anyone able to assist? The error is point it too the end of the document Thanks in advanced

I've got about 5 or so tables in my Back End. Now when I pull this query on the forms OnLoad event so I can save the data no forms are displaying. But if only display 1 table in the query they do show. Is there a limit I can only seem to have only 2 tables referenced at once. Thanks

I'm having major issues in an access form where I run a Query and it populates 10 fields or so. From those populated fields I run another query based on a fields value. Now the 2nd query at some point is trying to run when the fields value is not populated, so i'm getting errors. Its a...