Tag: ms-access

If a combo box = Closed, rejected or cancelled then display today’s date in text box. for example I have a combo box that has closed open rejected and cancelled. If someone chooses closed rejected or canceled then I need a text box to display the current date. I tried the below code but not sure where to put it.

I have events that are being treated differently based on whether or not expenses have 0 attendees. Each event has a unique code with several expense line items. If the attendee field has ALL 0 for each expense in this event code, then I need to append the method field to say method 1, for each expense with this event

Let’s say I’ve got 3 product description fields with the values AC-120 XXX, AC-120,CCC and AC-120 BBB. How would I get that information from a table using only AC-120 as my search argument? I’ve tried using the subStr function but that won’t return any values either Answer LIKE is very appropriate for this comparison. However, MS Access uses different wildcards

I want get the last date of each service. I would like to achieve the following: I tried this but it just get the record when the selected service have the last date Answer I think you want: