trying to get a weekly status report

[Samantha Mattie]

I'm trying to get a weekly report with the following things:

Artist's name (We have a few)

Thier totals for the last week (How many images they got done and put into Production)

Everything I've tried I can't seem to get working. I don't get proper totals. Please I'm begging help!

[BobWeaver]

You haven't provided any information on how your database is set up. Specifically, do you create a record for each image completed, or do you just have some other arrangement? If it's the former, then generally, you should create a report layout with a subsummary field grouped by artist. And you will need to create a summary field to total the images.

If you provide more details about the structure of your database, we can be more specific.

[Samantha Mattie]

We have records of each order, and each order we currently have how many of each product that bought and drop down of which artist worked on that order. Also I have it so as soon as they work on the order they click a check box and it gives the date it was worked on.

Some orders can have 20 different bags while other orders will have just one. My boss wants the number of bags each artist worked on for that week. Everything I've tried I kept getting the wront results.

[BobWeaver]

It sounds to me that you have multiple fields in one record to hold multiple sale items. If so, this is not the best structure for trying to manage your data. Could you provide a list of the fields involved and brief description of each?

Or possibly post a stripped down copy of your file?

Edited October 6, 2006 by Guest