Page 2 of 2 FirstFirst 12
Results 16 to 18 of 18
  1. #16
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    14,576
    I downloaded the file from filebin, then did a compact repair and have attach it as a zip.

    A few quick observations:

    -field names have no meaning
    -table has NO PK

    I have a database with Clients Names (Field1) , Programs (Field2), and Dates (Field3)
    I only see field3 and field5



    I later created a query to get Jan 2021 records (not included in the zip file)

    Code:
    SELECT [066 MED UPDATE].Field3
    , [066 MED UPDATE].Field5
    FROM [066 MED UPDATE]
    WHERE 
    Month([066 MED UPDATE].Field3) =1
    AND
    Year([066 MED UPDATE].Field3)=2021
    ;
    You could create a form with 2 txtboxes to select Month and Year for which you need records.

    But it seems there is more to the requirement, and certainly more required of the design, to have an operational database.
    Attached Files Attached Files

  2. #17
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,736
    I later created a query to get Jan 2021 records
    They are there in the drop box file - see below. Perhaps they were removed accidentally (they're not sorted).
    Maybe I copied the wrong sql, but what I tried worked in my version. I get these same records. I agree with the other stuff, but figured most of what I saw was just for playing around with.
    Field3 Field5
    1/01/21 DAOUD
    1/01/21 GRAY
    1/01/21 MOZAS
    1/01/21 KIM
    1/01/21 CINTRALEITE
    1/01/21 MCCRIMLISK
    1/01/21 PAMAN
    1/01/21 DOMKE
    1/01/21 STILLMAM
    1/01/21 PIZAPPI
    1/01/21 LOWE
    1/01/21 FELIX
    1/01/21 YUSIM
    1/01/21 AGUIN
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #18
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,736
    I later created a query to get Jan 2021 records
    They are there in the drop box file - see below. Perhaps they were removed accidentally (they're not sorted).
    Maybe I copied the wrong sql, but what I tried worked in my version. I get these same records. I agree with the other stuff, but figured most of what I saw was just for playing around with.
    Field3 Field5
    1/01/21 DAOUD
    1/01/21 GRAY
    1/01/21 MOZAS
    1/01/21 KIM
    1/01/21 CINTRALEITE
    1/01/21 MCCRIMLISK
    1/01/21 PAMAN
    1/01/21 DOMKE
    1/01/21 STILLMAM
    1/01/21 PIZAPPI
    1/01/21 LOWE
    1/01/21 FELIX
    1/01/21 YUSIM
    1/01/21 AGUIN
    EDIT - I had to drop this reply ASAP as I was being summoned by the boss (wife) so didn't have time to respond to
    But it seems there is more to the requirement,
    I would agree with that, at least from the point of the month having to be dynamic - i.e. if I run it next month, it's based on February, but 2021. Hard coding the month like that won't do it, unless maybe it's form driven. I think I've contributed all I can until there's any further feedback on what worked or didn't.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. DateAdd
    By Burnsie in forum Access
    Replies: 5
    Last Post: 01-29-2018, 08:02 AM
  2. Replies: 7
    Last Post: 02-09-2015, 12:35 PM
  3. the DateAdd
    By azhar2006 in forum Queries
    Replies: 1
    Last Post: 04-20-2014, 03:18 PM
  4. DateAdd()
    By cbrsix in forum Programming
    Replies: 3
    Last Post: 11-22-2011, 02:20 PM
  5. dateadd help
    By dubsdj in forum Queries
    Replies: 3
    Last Post: 03-03-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
  •  
Tech Forums: Microsoft Office Forums