Access help

Hello everyone.

I have an access problem. I am trying to create a query that will show me a field only when there is a quantity in that field. I know this is probably very simple to do but I don't know Access at all.

 

Put in the Criteria Row for that Field
Is Not Null

 

That works but here is the problem. This something that we are going to send to a jobsite. The data that I have has dozens of customer part numbers for. What I am trying to do is show the customer part number with the building floor number when there is a quantity entered. For example:

If a customer orders from us 500 of their part number "Gasket A" but its spread out among 15 floors of a building than I want the display the cusomer part number with a bulleted style list underneath it with all of the floors it was used on.

Does this make any sense?

 

I am attaching an example of what I am working with.

What I need is for the "Mark" or "Tag" number (which is really the customer part number) to show the total number of frames per floor.

 

Run a report and group by pathnumber and then jobsite. If you have the floor numbers in the dataset then you sort by those to put them in numerical order and have a total at the bottom of the group.

If you want to summarize by floor then add that in as a tertiary group.

 

Charles, I have some questions about your database.
First and most important, you have no Relationships set between the various tables.
How is the data related particularly the 2 Frame and Floor tables?