Make Table as per Date Range

Hi all,

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.
Who is Participating?
Why do you need a table for a range?
You can use queries with data range criteria.

To assign New, you can achieve that using update query.

If more help is required, upload a sample database with instructions on what to expect.
PipMicAuthor Commented:

Sorry for the delay... I will try your idea about the update query...will get back soon...thanks
PipMicAuthor Commented:
Good advice
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.