Recent content by Dr Peter Klomp

Thanks, Guys I took a bit of both of your answers, and OnLoad of the Report put this code: If txtboxTax - Int(txtboxTax) > 0 Then txtboxTax.DecimalPlaces = 2 Else: txtboxTax.DecimalPlaces = 0 Thank you again.

Yes. I need the tax calculation to be added into a total amount. The reason I don't want to show decimals unnecessarily is purely because of asthetics. When a client sees a bill for, say, $129, they won't fee as bad as seeing a bill for $129.00. Seems weird, but that is the psychology of it...

Yes, 75.3 should show as 75.30

I have a text box in a MS Access report that calculates tax from the value of another text box in the same report. I want the tax calculation to show whole numbers only, unless there are cents. For example, either 75 or 75.25. What should I put in the Property Sheet? I don't (think I) want to...

Hello Can anyone please tell me why the last part of this VBA code I'm using for MS Access is not working? FirstName = DLookup("[EEFirstName]", "qryDelegateBookingDetails", "[Delegate] = True And [InvoiceNow] = True And [Attended] <> ' "Cancelled" ' ") The problem seems to be the string...

Thank you everyone for your assistance and comments. My problem is solved, however, I will examine all the comments to see if there are improvements I can make to the way I query the data. Best regards.

Doc Man, You are the man! the DMin function was very sneaky, and worked perfectly. I didn't even think of it. So, problem solved. After a few hours of scatching my head, I do wonder what was wrong with my iif function. But, who cares, now? Thank you again. Cheers

Thanks, Doc Ultimately, the end result is the number of invoices we send out. If one record with the field "InvoiceNow" is checked true, then we want the query to extract that record only and we will issue an invoice to that person. However, if no records have been checked true for the field...

Thank you for your quick reply. If there is more than one record with InvoiceNow = true, then I want those records listed in the query, but if no records have InvoiceNow = True then I want all the records listed. I can get the user to input criteria of -1 or 0 (true or false) but I am trying to...

Hi Team, This is my first post, so bear with me if I am not following protocol. I am trying to write an MS Access query (not VBA) whereby, in the criteria box, I want records returned according to certain criteria. The table is debtors and one field is InvoiceNow which is a true/false field. If...

Hi Team Just joined the forum. But have been reading your various posts for some time. I'm from Australia. I have designed my own database, and do a bit of (very simple) VBA programming from time to time to oil the wheels. Looking forward to chatting with whomever from wherever. Regards Peter