Search results

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...

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