Search results

Hi I have attached a reduced form of the database with no personal detail. Just dates. Please help.

Hold up a minute. I just notice last the dates in the 2, 3 etc columns are over a month into the future. I only want it to show check that need to be made within the next month. As attached If I attached the database could you help.

Okay How would I do that? Would it be the tick boxes or dropdown menus? And how would I then sort the query so it excluded the resigned people? Thanks

Its the same field. They go through 3 stages. 1st tick box is 'Pre Reg Driver' 2nd is 'Live' and 3rd is 'Resigned' There is only 1 box ticked at once. The field is still saved as 'Resigned' for 12 months. Hope that helps.

SELECT [CTC LMA DA Table].ID, [CTC LMA DA Table].[First Name], [CTC LMA DA Table].Surname, [CTC LMA DA Table].[Next Passport Check Date], [CTC LMA DA Table].Hemel FROM [CTC LMA DA Table] WHERE ((([CTC LMA DA Table].[Next Passport Check Date])<Date()+28) AND (([CTC LMA DA Table].Hemel) Is Null))...

Hi I have created a query for telling me the dates when I need to check driving licences from my drivers. I have also made a Yes/No check box for when they are 'Live' employees and another Yes/No check box for when they have left. I need to exclude the records from the query with the 'Left...