i know solved but have one last question in this regard
could the query you made, be altered also to look at dates missing based on today's date
as I'm a bit behind in work and haven't been updating it on time, but still says missing only up to 21/6/20 but today's the 3/7/20 and i haven't...
so have a front end which is just used to find and open a PDF file, bit quicker and better looking then searching through file upon file.
but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject.
but what i would...
but one last thing, if i put in the coverimage part of the table "NoImage", which is the name of the image in the gallery for when i have no image yet, for the rest of my records
all it shows is the NoImage even if i had an image, why ??