Record Count x Price = Total

[Guest]

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.

 

[Guest]

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.

 

[Guest]

For Record Count in the report, you can use =Count([RecordName])
I am not sure about second one.

lkhsu