query question

[kato68]

I have two tables. One is a permit table and the other is a fee table. The permit table contains all the data about each permit and the fees table contains all the fees broken down. So for each permit you can have 3 records of fees in the fees table.

The report I want to create would contain all the data about a certain permit, but I also what to print one certain type of fee. I can not figure out how to do this without a subreport, which seems stupid to use for one textbox.

How would I be able to show the one type of permit fee?

Oh yea, and sometimes the the type of permit fee I want is not in the table, so if I try to query it on "building" (the type of fee), if there is no building then I get errors and no data is returned.

I hope this makes sense, if was very complicated to write.

 

[WayneRyan]

kato,

In the query design mode, join the two tables.

In the report "do not display duplicates".

As for the last part, if you have inconsistent data then
you must fix it. Either add the "orphans" for your main
table or change them to something like "Misc.".

Wayne