I've have already tried this, but still no joy. I think the solution is in the criteria field, where I have asked for all records were the status is 'not complete'. Therefore, what I want the query to show are all the call reports where the Status is 'Not complete' and all the empty call...
I have 2 tables, 1 is were all new maintenance issues are logged named 'logged calls table'. The 2nd table is were I report on these maintenance issues named 'call report table'.
Both tables have a related field called ProblemID which I use to match all related call reports to the logged call...
I am creating a maintenance database for the Hotel I am managing and have hit a snag. Basically I have 2 tables, 1 is were all new maintenance issues are logged named 'logged calls table'. The 2nd table is were I report on these maintenance issues named 'call report table'.
Both tables have a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.