A
anthony.carter
I have set up a query on a table that will return all the entries (ie
those premises) that have not been visited in the last year. In fact
the same query has been successfully adapted to three other tables.
Until I try it with a new table. Using the same category of fields,
the same formula and chanting the same incantation - the result is
blank.
I reiterate that the same fields with the same sort of information are
used for each of the queries.
Furthermore if I try to create exactly the same query for one of the
tables that already works, but give it a different name, it won't work
either.
Could someone help me see the wood for the trees please?
Thanks,
Regards,
TC
those premises) that have not been visited in the last year. In fact
the same query has been successfully adapted to three other tables.
Until I try it with a new table. Using the same category of fields,
the same formula and chanting the same incantation - the result is
blank.
I reiterate that the same fields with the same sort of information are
used for each of the queries.
Furthermore if I try to create exactly the same query for one of the
tables that already works, but give it a different name, it won't work
either.
Could someone help me see the wood for the trees please?
Thanks,
Regards,
TC