The idea I am trying to develop is the following:
I have a table of clients
Each has a status eg StatusA, StatusB, StatusC.
Each Client has a Date of Commencement (DOC)
I am trying now to create a temporary table whereby when I enter a date range in a form I want all clients that are StatusA and whos DOC falls within the Date Range entered to be assigned as "New"
I am attempting it by creating a make table query but I am having difficulty in creating the necessary expression to assign the client.
Grateful for assistance.