Search results

I'm a little confused, obviously, I can't put the format command in the SQL syntax. Am I supposed to put the nz command somewhere else besides in the sql statement? Here is the current statement SELECT [Invoices].[Date], [Invoices].[Vendor], [Freight].[PCBX], [Invoices].[InvoiceNum]...

Hello I really could use a hand with this as I want to get this project off of my desk I am using an sql statement to populate a report. Anyway, thanks to this board, I learned about the NZ function. This has made my reports work properly as far as the totals go. However, I can no longer...

Kim, I must admit, that I feel pretty dumb for not realizing this myself Who thinks about math when coding Joe

Thanks again.. I have been doing a lot of research the last couple of days, and must say that this VBA stuff is a lot more fun then my normal job of unix c programming btw this is kind of wierd. My roomate's name is John Holmes - odd. Joe

that worked great! Good idea.. if you wouldn't mind explaining one thing for me... Dim strSign As String * 1 what is the * 1 for? Thanks, Joe

Hi, I'm outputting an asci report to be imported by a seperate accounting package. For numbers I need the format to look like this dddddddddcc(+-) where d is dollars, c is cents, and it is followed by a plus or a minus (no parens). I am using the format command and have everything working...