Can't run a query/report based on 2 tables 1

[dranieri]

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 related field called ProblemID which I use to match all related call reports to the logged call report.They also have a Status field that tells me whether the call is complete or waiting on parts etc.

My problem is that I want to create a report that shows me all the logged calls and their related call reports. As some of the logged calls are new and do not have any call reports as yet, my report only shows logged calls that have a call report. I want the report to also show the new logged calls. This report is based on 1 criteria, and that is that the Status field is not set to "Complete". So I need all outstanding logged calls.

I hope this is enough explaination of my problem, but if not, please let me know what else you need. I am not a programmer so any non code answers would be greatly appreciated.

 

[danvlas]

Your report is based on a query.
Open the query in Design view, right click the join line and select Join Type (or Join Options).
Select Option 2 or 3, whichever results in an arrow pointing to 'call report table'
Run the query.
If that's what you need, save the query.

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Tom123456]

Thanks Daniel!!, that helped me a lot. I´m well understod with SQL but when I changed the jointype in SQL view it all went wrong

- Tom

 

[dranieri]

Danvlas,

Works like a charm. Thanks for the tip. I can finally sleep.