Search results

AN60 You can set two calendars to add dates into two textboxes on a form. ('StartDate" and 'EndDate') In your query refer to the form's textboxes to draw the dates for your between function. There is also a great calendar that is not an ActiveX here. Lebans Good Luck Tom

geoffD I guess I forgot to mention the second query. Glad you got it. Tom

Geoff Your on the right track with the Union Query. It sounds to me like you need something like this... If there is no Inbound the first part of the query will assign a 0 in the In column. Same goes for the Out column is the second part of the query. Change the field names to fit your db...

Hey I got it! I went to the underlying querys and added the format like this... Retail: FORMAT([Cost]*[Quantity],"CURRENCY") Thanks for the help Tom

llkhoutx I did as you suggested and found this white paper; ACC2000: Rounding Errors When You Use Floating-Point Numbers It says to change the data to 'currency' to correct the problem. So I'm back to square one. Can I force a UNION QUERY to produce the CURRENCY format? Thanks Tom

llkhoutx I tried formating just the report, but I still get the 'one cent discrepancey' in my results. example: If the query adds these values... 351.7609803 41.9039927 6.44755785 117.7141347 The result is 517.82666555 which rounds-off to 517.83 If the query adds these values... 351.76...

Hi I am combining two querys with a union query. qryRetail and qryVisit Both querys have cost columns that are set to Currency. When I run the union query I lose the formatting. I wind up with the data having several decimal places at times. This causes that annoying one cent discrepancey on...

Bravo! Jon you fixed it! Thanks Tom

Hi I have a union query that is putting together info from three other querys. The problem I have is that it will ignor duplicate values. For instance if the [QryCOPartUnion] PaymentType = Cash, Retail = $10.00 and [QryCOPracUnion] PaymentType = Cash, PVisit = $10.00 only one $10.00 value...

Andy Put another field in your table named Application. Set it to numeric. On your form you could have a text box tied to this field. You give instructions, by way of a textbox, to your users to enter a number between 1 and 5. Then add another field in your table named ApplicationMemo. Set it...

Andy If it were me, I would make a table for the appraisal too. As each Appraisal is one record I would make just one table. Make an Appraisal form. Your Name and Appraiser ect. would be combo boxes tied to the employee details table. Then I would make a series of radio buttons and check boxes...

Thanks for the help Wayne! Ah, yes the quotes signify a string. I missed that. As it turns out, the numeric 1 buys me exactly what I needed. Tom

Hi I have a Union query that is giving me results from two tables. One table has the field 'PractitionerID' The other table does not. I am using this SQL statement to get the 'PractitionerID' into the recordset. The next step is to get the Practioner's name into the data. I use another...

I was hoping you wouldn't say that. Back to the Report drawing board. Thanks for the help! Tom

My Invoice form has a sub form for 'Products' and also a sub form for 'Practitioner Visits' I am trying to get the data from these two subforms into one query. I have buildt a query that has the 'Invoice Products' table and the 'Invoice Practitioner Visits' table. I am trying to join them...

Pat How you made any sense out of my above post, I do not know. However once again you have solved the entire problem that has been vexing me for weeks. Thank you Tom

I do have one more question. How do I get the 'Return Total' to be negative? Can I do some formatting in SQL. I'd like to make it red too if I can. Thanks again Tom

Ah... Its coming to me now! Thanks again Pat. Tom

deejay Sometimes conditional formating works for these situations too. In forms design view format>>Conditional formatting Good luck Tom

Thank you both for your replys. Len, I think I would like to accomplish this using just querys if I can. Pat, this is very close to what I would like. The problem now is that the Invoice Amount and Return Amounts are now in the same column and I have no way of knowing which is a return and...