Generating MS Access Queries and Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am running a Access Database for machine breakdowns. Whenever a machine
breaks down, an access form is filled containing Machine Number, Location,
Description of breakdown, etc.

Now, at certain times, the machine number may not be entered it but ONLY
it's LOCATION.

From time to time, I need to generate a report listing all the machines with
their problem description and other details.

Currently, the headings I have are:
Machine Number, Asset Desc, Prob Desc, Date received, etc.

However, the listing does NOT list those machines has no Machine Number
recorded down initially.

How do I generate a report listing ALL breakdowns. If there's no machine
number recorded, I would stil like to add them in to the report.

How do i do this?
 
Apparently you aren't telling us something about your report and/or its
record source. I expect your report's record source query might contain an
INNER JOIN? If so, consider changing the join type.
 
Hi Duane,

I'm pretty new to MS Access and hence, do not really understand the
terminology used in this program.

Anyway, I have played around a bit with the types of joins that I'm using to
link the tables together and miraculously got it to work. Hence, problem
solved!

Thanks!
 
Back
Top