I need to take the database we have and have either another layout or database added to give reports.

How it's set up, status of the products (In Graphics, In production, Shipped) is a drop down list as is the product quantity list per customer. Now I need to be able to pull certain information from it. Like how many small bags are in Graphics, or how many large purses were shipped.

I can't seem to be able to pick all the the various bags in Graphics without having the total from In Production and shipped along with it.

I don't even know where to begin to do this.

Is it possible for you to post the file?

If the data is sensitive I would really suggest hiring a developer to protect your data better, otherwise, go ahead and post it, lots of people he can help you out!

This is just a sample database, with no bag orders, but the same setup as the live one.

There is a section for status, with In Graphic, In production, In production: Avo, and shipped.

No, I was to create a layout showing me a total for each bag that are in graphics, or in production and such. The closest I came was showing bag totals for the entire database. I'm really at a loss.

Samantha, take a look at this posting for some examples.

Posting