Advertisement

05.15.2008 at 07:06AM PDT, ID: 23405122
[x]
Attachment Details

Use IIf statement in query to select the earliest of  3 or more event times

Asked by matillma in Access Coding/Macros, Databases Miscellaneous, Microsoft Access Database

Tags: MS, Access, 2003

I have at least three Event Types (60, 60070 and 65) associated with a patient leaving the department.  A given pt could have any, or all valued in a single record, discrete date/timefields   I need to create a value called Departure that is the earliest time associated with any these 3 events.  In Excel, this would be a simple Min thing.

There are other times I might need to capture the earliest of 4 events.  

I have no VBA or SQL expertise, but much MS Access query experience, so I need this to be in the form of query criteria or an iif statement.  I have no problem with multiple queries I can put into a macro.  

I am building a data warehouse because we have over extended report writer support and I want to be able to run ad hocqueriesStart Free Trial
 
Keywords: Use IIf statement in query to select the …
 
Loading Advertisement...
 
[+][-]05.15.2008 at 07:35AM PDT, ID: 21574083

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.15.2008 at 07:43AM PDT, ID: 21574171

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Access Coding/Macros, Databases Miscellaneous, Microsoft Access Database
Tags: MS, Access, 2003
Sign Up Now!
Solution Provided By: hnasr
Participating Experts: 1
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628