Creating a "Count Query"?

SegaBraves

New member
Local time
Yesterday, 19:45
Joined
Sep 15, 2008
Messages
6
Hi All,

I've attached a screen shot to better understand what I'm trying to accomplish...

I'm trying to create a count query in which Field A will multiply by Field B to give us the ending result in a new column labeled "Total".

How would I go about doing such? I'm puzzled. I've played around in the Design View with the total row, but I can't seem to get things working...
 

Attachments

  • total_calc.jpg
    total_calc.jpg
    27.8 KB · Views: 130
In the grid, write:
Code:
Total: [fieldA] * [fieldB]
In SQL view, write:
Code:
SELECT ([fieldA] * [fieldB]) AS Total
BTW, thank you VERY MUCH for the easy question. :)
 
In design view of the query, type this in a new column, in the first row:

TotalField: FieldA * FieldB

substituting your actual names for the 2 field names.
 
Thanks for the quick responses.

Edit: Got it thanks guys! Sorry for the easy question, newbie here trying to learn the basics :)
 

Users who are viewing this thread

Back
Top Bottom