Results 1 to 6 of 6

Thread: Help with a query Please.

  1. #1
    Join Date
    Sep 2011
    Posts
    11

    Default Help with a query Please.

    I want to set up a query to search albums by decade, but don't seem to be able to get it to work. Any help would be appreciated.

    Thanks.

  2. #2
    Join Date
    May 2007
    Location
    Posts
    136

    Default

    Well that going to depend on what date you are searching one. Myself I just use the release date on the first edit form. It has a drop down form to enter day month year, but I just use the year.

    I tried just using the year in the search but that didn't work. I found that you had to enter the year as 00/00/1960 for example.

    So a search entered as:
    Release Date occurs on or after 00/00/1960 AND Release Date occurs before 00/00/1970

    works... for the 1960's (unless of course you consider the to be from 1961 thru 1970 as some do)

    fred

  3. #3
    Join Date
    Mar 2011
    Location
    Carlisle, UK
    Posts
    21

    Default

    I presume if you want to find all albums in a particular decade, e.g. the 1980's, you could use the query to search for all albums whose Year begins with "198".

    Additionally you could add further conditions to refine your search.

    Steven

  4. #4
    Join Date
    May 2007
    Location
    Posts
    136

    Default

    Yea... that's even easier.. ;O)

    fred

  5. #5
    Join Date
    Feb 2009
    Posts
    1,549

    Default

    Quote Originally Posted by sbeck201 View Post
    I presume if you want to find all albums in a particular decade, e.g. the 1980's, you could use the query to search for all albums whose Year begins with "198".
    Steven, awesome. I was just about to recommend a way to build complicated query to achieve same purpose, but your way is of course much simpler.

    Andrei

  6. #6
    Join Date
    Sep 2011
    Posts
    11

    Default

    Fantastic! thanks.

Posting Permissions

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