division in access query from separate tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several tables I'm running a query from. Simply trying to take one
number from table 1 and divide by another number from table 2 and it's making
me nuts. Totally new at expressions. Please, I'm at your mercy. Help.

Autumn
 
Dear Autumn:

Nice name. I'm more of a Spring person myself, but I haven't yet met her.

To try to help, could you please post the query you have so far and explain
what it isn't yet doing, or is doing incorrectly.

A simple mathematical expression would be very simple. I'm expecting there
must be something more to this. We'll see!

Giving a bit of sample data and what result you expect might also be very
useful. This may bring me up to speed quickly.

Tom Ellsion
 
Figured this one out on my own! Yeah! And they don't have to commit me -
yet. It was a very simple one and my biggest problem, I was trying to build
the expression on the wrong line.

Payment:[amount]/[divider]

That simple. Just the wrong cell. oy. Thank you for nice compliment too.
Nice to hear nice things. Matter of fact we have a Summer, Sundae, Rheiny in
our family. No kidding. Sounds like a bunch of hippies. Thanks again.
Autumn
 
Dear Autumn:

So, can you arrange an introduction for me to Summer? : )

So, it really was the simple thing.

oy! ma shalomka?

Tom Ellison


AutumnK said:
Figured this one out on my own! Yeah! And they don't have to commit me -
yet. It was a very simple one and my biggest problem, I was trying to
build
the expression on the wrong line.

Payment:[amount]/[divider]

That simple. Just the wrong cell. oy. Thank you for nice compliment
too.
Nice to hear nice things. Matter of fact we have a Summer, Sundae, Rheiny
in
our family. No kidding. Sounds like a bunch of hippies. Thanks again.
Autumn

Tom Ellison said:
Dear Autumn:

Nice name. I'm more of a Spring person myself, but I haven't yet met
her.

To try to help, could you please post the query you have so far and
explain
what it isn't yet doing, or is doing incorrectly.

A simple mathematical expression would be very simple. I'm expecting
there
must be something more to this. We'll see!

Giving a bit of sample data and what result you expect might also be very
useful. This may bring me up to speed quickly.

Tom Ellsion
Click to expand...
Click to expand...
 
Back
Top