Search results
-
T
Date Range in a Query
Sorry should have given my expression. Expr1:[Club]![Birthdate]=DatePart("m",#1/1/1910#)- tmulrooney
- Post #5
- Forum: Queries
-
T
Date Range in a Query
Thank you. Idea by Jack Cowley is somewhat working. It is extracting all dates/ all months including the entries without birthdays entered. As my Adate I used 01/01/1910. It queried back all entries. Any idea what is going on?- tmulrooney
- Post #4
- Forum: Queries
-
T
Date Range in a Query
I am trying to create a Birthday Query. I want to extract the data per month. It is entered into my table in ##/##/#### format. I have tried the between ##/##/#### and ##/##/#### but that only gives me results for a particular year. Ex. I need every birthday in march for every year...- tmulrooney
- Thread
- Replies: 5
- Forum: Queries