If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Over my head in Access
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 |
#2
|
|||
|
|||
Over my head in Access
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 "David" wrote in message ... 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 |
#3
|
|||
|
|||
Over my head in Access
"David" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|