setting up a query

  • Thread starter Thread starter chase
  • Start date Start date
C

chase

I am stuck on how to set up a query and have it operate
on my table. I have tried to format it under "query"
and "update query". The end result is to have the data
in one column of my table be divided by the data in
another column and then display the quotient in a 3rd
column. I have set up the query as below but it does not
work.
(desired result)
(column 1) (column 2) (column 3)
field A B C: [A]/
table (file name) (file name) (file name)

Would appreciate help in setting up the query so that it
will operate on the table to give the desired results.
 
This should work. When you say "does not work", you need to be a little more
specific.
[A]/ assumes:
1) both fields are numeric
2) neither field is null
3) is not zero

BTW: there should be (table name) not (file name)
 
Duane, thanks for your reply.
I meant to say "table" instead of "file name". I did
double check the data in the fields that they comply with
the assumptions. There was one field that had a null
value. I entered a value for that field. Both fields
are numeric. There is a $ sign in one field. Would this
affect the query? Specifically, [A] = 'saleprice' and
= 'sqft' and I want C which is $/sqft. When I say it
doesn't work, I mean when I save and close the query and
then open the table, nothing appears in the
column '$/sqft'. I'm sure it is something simple, but I
cannot figure it out. Thanks for your help. Any more
advice would be appreciated.

Chase
-----Original Message-----
This should work. When you say "does not work", you need to be a little more
specific.
[A]/ assumes:
1) both fields are numeric
2) neither field is null
3) is not zero

BTW: there should be (table name) not (file name)

--
Duane Hookom
MS Access MVP


I am stuck on how to set up a query and have it operate
on my table. I have tried to format it under "query"
and "update query". The end result is to have the data
in one column of my table be divided by the data in
another column and then display the quotient in a 3rd
column. I have set up the query as below but it does not
work.
(desired result)
(column 1) (column 2) (column 3)
field A B C: [A]/
table (file name) (file name) (file name)

Would appreciate help in setting up the query so that it
will operate on the table to give the desired results.
Click to expand...



.
Click to expand...
 
You say you "save and close the query" but then "open the table". You can't
define calculated columns in a table. You must use the query. There is
generally no go reason to "save" a calculated value.

--
Duane Hookom
Microsoft Access MVP


chase said:
Duane, thanks for your reply.
I meant to say "table" instead of "file name". I did
double check the data in the fields that they comply with
the assumptions. There was one field that had a null
value. I entered a value for that field. Both fields
are numeric. There is a $ sign in one field. Would this
affect the query? Specifically, [A] = 'saleprice' and
= 'sqft' and I want C which is $/sqft. When I say it
doesn't work, I mean when I save and close the query and
then open the table, nothing appears in the
column '$/sqft'. I'm sure it is something simple, but I
cannot figure it out. Thanks for your help. Any more
advice would be appreciated.

Chase
-----Original Message-----
This should work. When you say "does not work", you need to be a little more
specific.
[A]/ assumes:
1) both fields are numeric
2) neither field is null
3) is not zero

BTW: there should be (table name) not (file name)

--
Duane Hookom
MS Access MVP


I am stuck on how to set up a query and have it operate
on my table. I have tried to format it under "query"
and "update query". The end result is to have the data
in one column of my table be divided by the data in
another column and then display the quotient in a 3rd
column. I have set up the query as below but it does not
work.
(desired result)
(column 1) (column 2) (column 3)
field A B C: [A]/
table (file name) (file name) (file name)

Would appreciate help in setting up the query so that it
will operate on the table to give the desired results.
Click to expand...



.
Click to expand...
Click to expand...
 
Back
Top