If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Queries adding Zeroes
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 |
#2
|
|||
|
|||
Queries adding Zeroes
Still no answer?
HELP ME! -----Original Message----- 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 . |
#3
|
|||
|
|||
Queries adding Zeroes
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.) wrote: Still no answer? HELP ME! -----Original Message----- 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 . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Imported Queries & Field Names - Attn S.Clark MVP | Bruce | Running & Setting Up Queries | 3 | June 14th, 2004 12:14 PM |
seeming quirk with creating new queries from a2000 db /WinXP access/WinXPOS | SisterSun | Running & Setting Up Queries | 3 | June 9th, 2004 04:01 PM |
Help with using drop-down menus to limit choices when adding records or viewing queries | Mike H | New Users | 1 | June 8th, 2004 06:46 PM |
Queries in a Dropdown | Graham R Seach | General Discussion | 0 | June 4th, 2004 12:15 AM |
Exporting Multiple Queries to 1 Excel Workbook with VBA | Anthony | Running & Setting Up Queries | 2 | June 3rd, 2004 07:59 PM |