|
| 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
October 5th, 2005, 11:21 PM
|
|||
|
|||
Record Count x Price = Total
I'm a beginner. So, please be 'gentle'...
I have a report that lists all of the records I need. It also includes a counter to the left of the records. At the bottom of a report I need to display the Record Count x Price = Total. 1) How do I count the records and where do I count them (in a query or can I do it within the report)? 2) The Records come from the main database, but the Price I need to use in the calculation is in a separate table that lists the prices of multiple items. I'm not even sure where to begin and the reference books I have are absolutely no help on this. So, any suggestion is much appreciated. 
|
|
#2
October 6th, 2005, 12:53 AM
|
|||
|
|||
|
Another way of putting it is...
I need the count of a query, the cost listed in a table and the product of the two to be displaed in a report header. "ETC" wrote: I'm a beginner. So, please be 'gentle'... I have a report that lists all of the records I need. It also includes a counter to the left of the records. At the bottom of a report I need to display the Record Count x Price = Total. 1) How do I count the records and where do I count them (in a query or can I do it within the report)? 2) The Records come from the main database, but the Price I need to use in the calculation is in a separate table that lists the prices of multiple items. I'm not even sure where to begin and the reference books I have are absolutely no help on this. So, any suggestion is much appreciated.
|
|
#3
October 6th, 2005, 05:44 PM
|
|||
|
|||
|
For Record Count in the report, you can use =Count([RecordName])
I am not sure about second one. lkhsu "ETC" wrote: I'm a beginner. So, please be 'gentle'... I have a report that lists all of the records I need. It also includes a counter to the left of the records. At the bottom of a report I need to display the Record Count x Price = Total. 1) How do I count the records and where do I count them (in a query or can I do it within the report)? 2) The Records come from the main database, but the Price I need to use in the calculation is in a separate table that lists the prices of multiple items. I'm not even sure where to begin and the reference books I have are absolutely no help on this. So, any suggestion is much appreciated.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I count records, but not each comment under that record? | GrHopp | General Discussion | 1 | September 1st, 2005 08:45 PM |
| Creating Records in tables automatically | peterg290935 | Using Forms | 8 | June 22nd, 2005 08:12 AM |
| Grand Total Problem | PW11111 | Running & Setting Up Queries | 2 | March 11th, 2005 05:44 PM |
| Pivot Table Access 2000? | Air-ron | General Discussion | 2 | October 29th, 2004 06:19 PM |
| How to count the total records on a particular page | Irshad Alam | Setting Up & Running Reports | 1 | September 2nd, 2004 02:05 PM |
Linear Mode
