Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Access Combined Query

    I have four different fields that have dates in them for 4 different things and currently I run 4 different queries every month to show what expired that month (i.e. auto ins, drivers lis, physical date due, etc.) Anyway is it possible to do one query that will list of the folks who have one or more of those items due during the specified month say 03/01/2004-03/31/2004??

  2. #2
    Join Date
    Feb 2004
    Posts
    199
    combine where condition of your 4 queryes with OR statement
    Last edited by Kakha; 03-04-04 at 10:12.
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

  3. #3
    Join Date
    Dec 2003
    Posts
    138

    More details please

    Could you please be more specific....

  4. #4
    Join Date
    Feb 2004
    Posts
    199
    ok, write down your queries SQL (all 4)
    MDB, ADP <-> MS SQL + VBA, ADO & RDO, .NET, Oracle, Java/Jsp.

  5. #5
    Join Date
    Dec 2003
    Posts
    138

    More info

    my queries are done with basic expressions, i.e. for Auto ins it searches via the expression <date() and shows all persons whose auto ins is expired, same with drivers license but I don't like doing 4 reports especially if one person is on more than one report it would be easier to find their name and they would see all of the info that is due.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •