Over my head in Access

[David]

I'm trying to put together a database to keep track of sales and customers. I
think I have the database itself laid out right, what I need to do is
generate reports showing sales by user. I think I have to set up a SQL
statnent for this. Each entry has three money fields. What I would like to do
in the report is total the three fields for each entry, Then total the amount
of all the entries plus break the entries down into one number for sales and
one for service.

I know that I have to make a query to add up each money field, one for
deposit, one for payment, one for retainer. Can I then take those three
queries and add them together to get the total in another query?

Thanks,
David

 

[Jeff Boyce]

David

If the underlying table has "three money fields" that you are trying to
"total", it sounds like your table is more like a spreadsheet than a
relational database table.

Since it all starts with the data, please describe the table structure. How
you create a query will depend on how you have your data organized.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Margaret Bartley]

I'm trying to put together a database to keep track of sales and
customers. I
think I have the database itself laid out right, what I need to do is
generate reports showing sales by user. I think I have to set up a SQL
statnent for this. Each entry has three money fields. What I would like to
do
in the report is total the three fields for each entry, Then total the
amount
of all the entries plus break the entries down into one number for sales
and
one for service.

I know that I have to make a query to add up each money field, one for
deposit, one for payment, one for retainer. Can I then take those three
queries and add them together to get the total in another query?

You can total entries in a query by adding a new column, giving the field a
name like "Sales Total", and say [Money Field1] + [Money Field2], or
whatever the field names are that you want to total for each entry.

Then, in the report, you can total those fields and put the total at the
beginning of the report, in the header, at the end of the report, in the
footer, or have section breaks and put them in the section headers and
footers.

The key to know is that you can create new fields in queries by performing
arithmetic operations (or string manipulation) on fields in the record. but
you have to list the new field you are creating in the query after you list
the fields that you are using in that creation.