help with "or" criteia

[mish via AccessMonster.com]

I have a personal info table. it contains fields such as name,birthdate and
their hobbies. there are 4 hobby fields in the table and they are computer,
music,sport and movie. i use integer to represent those data where "1"
indicate YES ,that person like that hobby where as "0" = No ,that person is
not interested in that particular hobby.

the question is that i want to create a query to show persons who like
computer or sport.

i am new to Access i would be really appecrate if someone can guide me
through the steps to create this query.

thanks a lot

 

[tina]

i am new to Access

as an Access newbie, you're making a common mistake - storing data in
fieldnames ("Computer", "Music", "Sport", "Movie"). this is sometimes
referred to as "committing spreadsheet", and it breaks a basic rule of data
normalization. recommend that you stop *now*, learn the rules of
normalization, and redesign your tables/relationships, before you continue
building your database. if you don't, you're going to continue to run into
problems that you need to work around, due to a poorly structured database.

for more information, see the tips at
http://home.att.net/~california.db/tips.html, beginning with Tip 1 and Tip 2
in that order.

hth

 

[mish via AccessMonster.com]

i am new to Access

as an Access newbie, you're making a common mistake - storing data in
fieldnames ("Computer", "Music", "Sport", "Movie"). this is sometimes
referred to as "committing spreadsheet", and it breaks a basic rule of data
normalization. recommend that you stop *now*, learn the rules of
normalization, and redesign your tables/relationships, before you continue
building your database. if you don't, you're going to continue to run into
problems that you need to work around, due to a poorly structured database.

for more information, see the tips at
http://home.att.net/~california.db/tips.html, beginning with Tip 1 and Tip 2
in that order.

hth

I have a personal info table. it contains fields such as name,birthdate and
their hobbies. there are 4 hobby fields in the table and they are computer,

[quoted text clipped - 9 lines]

thanks a lot

ok i hv that store in another table now. but how can i search for people who
like computer or sport

 

[tina]

in a query, simply add criteria to the Hobby field, as

WHERE Hobby = "computer" or Hobby = "sport"

hth

i am new to Access

as an Access newbie, you're making a common mistake - storing data in
fieldnames ("Computer", "Music", "Sport", "Movie"). this is sometimes
referred to as "committing spreadsheet", and it breaks a basic rule of data
normalization. recommend that you stop *now*, learn the rules of
normalization, and redesign your tables/relationships, before you continue
building your database. if you don't, you're going to continue to run into
problems that you need to work around, due to a poorly structured database.

for more information, see the tips at
http://home.att.net/~california.db/tips.html, beginning with Tip 1 and Tip 2
in that order.

hth

I have a personal info table. it contains fields such as name,birthdate and
their hobbies. there are 4 hobby fields in the table and they are

computer,
[quoted text clipped - 9 lines]

thanks a lot

ok i hv that store in another table now. but how can i search for people who
like computer or sport