Results 1 to 3 of 3
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,095

    Can't seem to get the criteria expression correct

    Can't seem to get the criteria expression correct. DOB (Date of Birth) is a Date/Time datatype in table Registry. I'm simply wanting to obtain all the names whose birthdays occur in August, or any other months that get specified.



    Click image for larger version. 

Name:	DOB.jpg 
Views:	3 
Size:	23.8 KB 
ID:	22499

    What expression do I need?

    Thanks,
    Bill

  2. #2
    CJ_London is offline VIP
    Windows 8 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    1. remove your existing criteria
    2. in a separate column put Expr1:Month(DOB)
    3. untick the show option for this column
    4. in the criteria put 8

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 7 64bit Access 2003
    Join Date
    Feb 2011
    Posts
    2,095
    It would have helped if I had remembered the arg to MonthName is int rather than a date.

    Thanks much,
    Bill

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

Similar Threads

  1. Correct syntax for query expression
    By stevekos in forum Queries
    Replies: 1
    Last Post: 07-23-2015, 01:55 AM
  2. Replies: 1
    Last Post: 11-13-2014, 11:34 PM
  3. Replies: 8
    Last Post: 08-03-2014, 09:35 PM
  4. Replies: 3
    Last Post: 05-14-2013, 10:29 PM
  5. trouble creating correct criteria
    By pshawk in forum Queries
    Replies: 1
    Last Post: 02-12-2010, 01:52 AM

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