Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting dates from columns which have ? as 'null'

Status
Not open for further replies.
d44

d44

MIS
May 30, 2002
17
GB
I have taken imported an excell spreadsheet into Access and I am wanting to do a query on one of the columns (Date_of_Birth) which contains some date fields ones that that are blank are represented by a question mark or are just blank.

The format the date is represented is dd/mm/yy.It been a while since ive used access and I cant seem to remember what to use.Thanks
 
Sort by date Sort by votes
What do you want to do with the date fields? Do you want to perform a calculation on them or just update the ones that are ?'s
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

spartansFC
  • Locked
  • Question
Display Year between 2 dates 1
Replies
1
Views
494
dhookom
dhookom
serino
  • Locked
  • Question
Delete From Table
Replies
1
Views
501
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Jet Sql Statement - Select Distinct Multiple Columns 1
Replies
4
Views
542
Swi
Swi
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
2K
lameid
lameid
Hanss
  • Locked
  • Question
Query which shows results?
Replies
2
Views
194
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top