Search results

Problems using IIF with Dates as criteria in a query I am trying to use a IIF command in a query with date functions but can’t get it to work. I am trying to limit a list of Suppliers to a choice of all or the last 3 months. I have the following 2 parts working when used alone as criteria...

I am retired in Spain and have written a few databases both in the UK and here in Spain. I am familiar with Access and VBA but not at a high level. I tend to learn by trial and error and help from sites like this one. I don't think I am good enough to give advise but will certainly like some...