Results 1 to 5 of 5
  1. #1
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55

    date function

    Hi Guys

    I have a table which is a record of improvemets and the date of the improvement .This is linked to a table with run dates ,qtys ,scrap


    Is there a way of querying the records to identfy just the dates since the improvemnt without actually typing in the date.
    Something like query >date of improvement. Pulling the date of improvement from a table instead of typIng it individiually.
    I hope that make sense

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    8,188
    if the form is showing the Item Improved w the date,
    then a subform or query would be

    select * from table where [improveDate]> forms!fMyForm!txtImprovDate

  3. #3
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55
    Ok Thanks I will give it a go

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2016
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,824
    Can you tell us a little more about the application in plain English? What exactly is an Improvement?

    Consider a series of events taking place on certain dates. If you want to know which events happened after
    Jun 5, 2019, you would have a query along this set up.

    Code:
    Select * from MyEventsTable
    where EventDate > #06/05/2019#
    Good luck.

  5. #5
    chr1stoper1 is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    55
    Hi I used a form and ran a query which returned the data i needed thanks for help everyone

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 6
    Last Post: 04-03-2019, 02:44 AM
  2. Replies: 2
    Last Post: 06-25-2014, 11:00 AM
  3. Replies: 7
    Last Post: 02-25-2014, 03:11 PM
  4. date function
    By geraldk in forum Forms
    Replies: 13
    Last Post: 12-28-2011, 12:36 PM
  5. Date Function
    By joewhitt in forum Queries
    Replies: 7
    Last Post: 07-17-2011, 07:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums