Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Make Table as per Date Range

Posted on 2012-08-25
Medium Priority
Last Modified: 2012-09-03
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.
Question by:PipMic
  • 2
LVL 31

Accepted Solution

hnasr earned 480 total points
ID: 38332184
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.

Author Comment

ID: 38342700

Sorry for the delay... I will try your idea about the update query...will get back soon...thanks

Author Closing Comment

ID: 38360547
Good advice

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question