Help with queries please

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

I have set up a simple address table with a column for entries such as
p for postcard, c for christmas and w for wedding, how can I use
query to access each address if I only want the wedding addresses or
the christmas addresses etc, Some have a c, a w and a p in that column
but when I run a query just for p it doesn't pick that address up.

Is there any way round it or do I have to set up three columns one for
postcard, wedding and christmas.

Any ideas anyone?
 
You can use a wildcard * and the like operator to return what you want

SELECT table.column
FROM table
WHERE table.type Like '*P*'
 
oops query is slightly wrong

SELECT table.column
FROM table
WHERE table.column Like '*P*'

Sorry for confusion.
 
Tim

What are you planning to do when you need to add birthdays, Bar Mitzvahs,
and "first date" notations?

What will you do if you want to pick folks/address who have both birthdays
and Christmas?

Consider revisiting the topic of "normalization" in Access HELP -- it sounds
like you have a "one-to-many" relationship. In a relational database like
Access, you're better off handling this with a "parent" and "child" table
design.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top