Make Table as per Date Range

Posted on 2012-08-25
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
    LVL 30

    Accepted Solution

    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


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

    Author Closing Comment

    Good advice

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    This article is a continuation or rather an extension from Cascading Combos ( and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
    I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
    What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now