If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Query
The first thing that comes to my mind is this:
Create 4 separate queries (one for each category) Create a union query that combines the four queries created above HTH "katzy" wrote: It's been a while since I have used Access. I am trying to run a query so that I can use it for a report. I need to show dates for four different categories that are within a certain time frame for each customer name. Each customer can have up to four dates displayed (one for each category), but if the date is not within the time frame, then it will not show up. So, a customer can 1 to 4 dates listed, because if none are listed then the customer name will not be displayed at all. I figured maybe I should just do an if statement within the report, but I don't remember the notation for if statements anymore either! Here's a view of what I'm trying to do: Upcoming Expirations ----------------------------------------- Joe Business License: 09/15/05 Car Insurance: 10/09/05 Jane Car Insurance: 09/25/05 Worker's Comp: 10/01/05 Jill Liability: 09/30/05 James Car Insurance: 10/01/05 Liability: 10/01/05 Worker's Comp: 10/01/05 (John has no upcoming expirations so he is not listed) Any suggestions/help would be greatly appreciated! Thanks! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter query - nested queries | laura | Running & Setting Up Queries | 3 | February 10th, 2005 04:09 PM |
Moving from xBase/Clipper | [email protected] | New Users | 1 | February 3rd, 2005 07:25 PM |
adding 2 fields including null entries | Jesse | Running & Setting Up Queries | 26 | January 18th, 2005 05:31 PM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Too Few Parameters error Mail Merge Access Parameter Query | Tony_VBACoder | Mailmerge | 3 | September 14th, 2004 12:15 PM |