Recent content by liverpoolphil

I'm looking to identify those dates in column "4" that are within a set range but don't have a date greater than today in the cell(?) underneath, hope that makes sense and thanks for your input

Yes the fields are named 1,2,3,4 & Day In the image I posted....if I was to use my current query to search for 4's between 20/4 and 25/4 this customer would appear in the result BUT this customer has paid for a further block of 4 sessions (up to 23/5) so I don't want them to appear in my "list...

The image is a picture from a table ... I am (trying) to use a query to interrogate that table show show me those column 4's between a certain date but not beyond today

yes BUT also not greater than today

that's an image of my table, the dates are for appointments which are booked in blocks of 4 and I'm trying to interrogate the table to show me those Session 4's between a certain date but not beyond todays date (i.e. those who are finishing their block of 4 within a date range but haven't paid...

we sell our service in block of 4 (appointments) so each date represents an appointment. I would like to search the table for those who have completed their block of 4 (i.e the date in column 4 is less than today) but also to exclude people who have already paid (hence the date in their 4th...

thanks for your response bob fitz - Column's 1-4 are all date/time data types - this the information you're looking for?

Hi all, first post on here hope I can get some help with an issue I've been trying to sort out (and failed) I'm no access expert but cant seem to find a solution to something I think some of you may be able to solve easily I want to create a query which searches column 4 for dates within a...