PC Review


Reply
Thread Tools Rate Thread

Access 2007 Query Date

 
 
New Member
Join Date: Oct 2010
Posts: 1
 
      18th Oct 2010
I am new to using Access 2007. Please help if possible. I have an access 2007 query and I need to sort it by dates. I have 3 field dates... need to sort each field if not null.

I need for it to sort by field1 date first, and it field1 date is null, sort by field2, and if field2 date is null, sort on field3.

I hope I explain it good enough...I am a rookie.
 
Reply With Quote
 
 
 
 
Ian Ian is offline
Rocket Scientist
Ian's Avatar
Join Date: Feb 2002
Location: Manchester, UK
Posts: 16,071
 
      18th Oct 2010
Hi and welcome to the forums

Please only make one thread per issue, as having duplicates will confuse things . I've removed your old thread and moved this one to a section that may get some more answers.
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date format on exporting query to csv file from access 2007 Matt Microsoft Access External Data 3 17th Feb 2010 11:07 PM
Can Access 2007 automatically clear date field after date hasexpired? stevmich Microsoft Access Macros 2 23rd Jan 2010 05:56 PM
Access 2007: Query; Date Filters; After. Error: Includes date ty Stephen Microsoft Access 0 9th Jul 2009 04:32 PM
Re: Access Query to request record with date closest to todays date John Spencer (MVP) Microsoft Access Queries 1 29th Jul 2004 11:40 PM
Re: query date/time for entire date in access Gary Walter Microsoft Access Queries 2 25th Nov 2003 01:44 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:54 PM.