By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,736 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

query help pls - add totals of 3 fields with similar values

P: n/a
Hello,

I made a log book to record model rocket flights.
The table to record each flight has 3 fields that allow you to select
the type of motor used (some rockets can use more than one motor for
each flight). eg:

motor1
motor2
motor3

These fields are lookup fields from the table tblMotors.

I want a query that can total the motors used based on each type of
motor - ie: D21-5 total = 8, E9-8 total = 23 etc...

I can get it to total the motors from motor1 or motor2 etc, but I cant
get it to total the motors from all 3 fields.

Can anyone helps?

Thanks.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.