Queries adding Zeroes

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

hi,
i have a table which keeps track of lawyer membership in
different sections (i.e. criminal law, civil law, etc.)
by having their section dues (in a currency field) put in
the column. I want to run a query which filters out
members who have not paid their section dues. however,
when running this query the query adds zeros into the
columns that i have blank and eliminates the cents in
what was a currency field when the cents are zero. This
totally screws up my bills in word because there are no
cents where there should be and there are zeroes where
there should be nothing.

Can anyone help??

thanks in advance,
Rob
 
Well, since you didn't give any details, I - for one - chose not to attempt an answer.

Can you post the SQL statement that you are attempting to use?

Do this transmutation of data happen in the query or does it happen when you
insert the data into word?

Are you running the query from word? or are you running the query in Access?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

With the additional information, you stand a better chance of someone answering
the question. No guarantee and it probably won't be me, since I am going to
have grandchildren over tomorrow (and you and this group are much lower on the
priority list than the two boys.)
 
Back
Top