Multiple Entires in a record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working on a friends database. They have a series of differnet records
each records pertains to a piece of music, who played it and when. Some
pieces have been played in 4 or 5 different years. If I run a query to find
all pieces played in 2005 it only gives me those records where 2005 is sole
entry. How do I create a query or filter, that will allow me to find those
that are amongst other dates eg 1997, 1998 and 2005. Is there a way or am I
going to have to separate out all of the dates?

Thanks
James
 
It sounds like you are storing multiple year values in a single field. This
is considered a bad practice. A better solution would be to create a related
table that stores the primary key from the "piece of music" table and the
date the piece was played. If a piece was played in 3 different years, this
would create 3 records in the related table.
 
In the mean time (until you fix the structure), you can use criteria

Field: PlayDate
Criteria: LIKE "*" & [Enter Year] & "*"


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top