Results 1 to 2 of 2

Thread: a small filtering thing

  1. 06-13-2003, 01:27 PM #1
    BMan111
    BMan111 is offline Registered User
    Join Date
    Jun 2003
    Location
    Bloomington, IN, USA
    Posts
    116

    a small filtering thing

    Ok, here is what I would like to have, and please keep in mind that i am still a novice and IT wont give me VBA.

    I have a made a query that just takes the list of project numbers from my database, and puts them in one column and then looks at the part of it that designates year, and translates it into a 4 number year from a 2 number year. It then sorts them by year, and then project number.

    Ive been trying to find a way to run a query or something to get just ONE of each year into a seperate table, so that I can base a drop down off of the year w/o having ot go and type a new year in every jan 1.

    Anyone konw of any good filtering tricks to accomplish this?

    Brandon
    Reply With Quote Reply With Quote
  2. 06-13-2003, 01:36 PM #2
    schlauberger
    schlauberger is offline Registered User
    Join Date
    Feb 2003
    Location
    Earth, USA
    Posts
    81

    SELECT DISTINCT

    You could use the DISTINCT function in you SQL statement to prevent duplict data returns.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules