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

Yes/NO Query Question

P: n/a
WTG

Hope someone can help

I have records of fuel inventory, and I've used yes/no switches for
the different types of fuel.

ie: amount gas clear dyed

100 yes
56 yes
245 yes
50 yes
ect.....

now I want totals of the Gas, Clear, Dyed.

So Total Gas = 150
total Clear=56
total dyed=245

I've tried typing an expression in the query but nothing I try seems
to work :(

I know it must be simple, but I'm at a loss.

Can anyone help?

Thank You

Wally


Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Rog

WTG wrote:
Hope someone can help

I have records of fuel inventory, and I've used yes/no switches for
the different types of fuel.

ie: amount gas clear dyed

100 yes
56 yes
245 yes
50 yes
ect.....

now I want totals of the Gas, Clear, Dyed.

So Total Gas = 150
total Clear=56
total dyed=245

I've tried typing an expression in the query but nothing I try seems
to work :(

I know it must be simple, but I'm at a loss.

Can anyone help?

Thank You

Wally


Since Yes has a value of -1 in Access, you can make a "totals" query
with the following fields:

totalgas: -[gas]*[amount]
totalclear: -[clear]*[amount]
totaldyed: -[dyed]*[amount]
and Sum on the total line for each of these columns.

Nov 13 '05 #2

P: n/a
WTG
On 24 Jan 2005 08:12:43 -0800, "Rog" <de********@state.gov> wrote:
Thank You,
for the help

Since Yes has a value of -1 in Access, you can make a "totals" query
with the following fields:

totalgas: -[gas]*[amount]
totalclear: -[clear]*[amount]
totaldyed: -[dyed]*[amount]
and Sum on the total line for each of these columns.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.