Multiplying columns should not be difficult.....should it?

[Imamontanalady]

I have tried REPEATEDLY to figure out how to multiply columns. I feel like
an idiot because I cannot get it to happen.

This is what I have.

Column 1: Irrigated Acres
Column 2: O&M Rate
Column 3: O&M Charge (which is Irrigated Acres x O&M Rate)

Can someone explain how I do this in simple terms?

 

[Duane Hookom]

Assuming both columns are numeric, try:
OMCharge: [Irrigated Acres] * [O&M Rate]

I would strongly suggest you don't use symbols and/or spaces in your field
names.

 

[Jeff Boyce]

Are you trying to do this in a table? If so, stop now!

Create a new query in design view.

Add the table. Add those two fields.

Add a new field that calculates the product, something like (untested):

NewField: [IrrigatedAcres] * [O&MRate]

(I'm with Duane, try to avoid using symbols in your field names ... also
avoid spaces)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.