HELP - Please see Last post on 6/16/06

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

Guest

HELP - Please see Last post on 6/16/06
Query base on "yes/no" switch (data type) in table.

Any help will be greatly appreciated, I'm on a
time crunch.
Tom
 
Tom, I don't see the post you mention. Something must have happened to it,
will you please give me more information?
 
Wayne,
I have a table that is for Deliveries.
The schedule may call for deliveries between
certain dates, that take place on, for example,
"monday" "wednesday" "friday"
I have the days of the week, each seperate
and defined as "yes/no" in data type.
on my form, these are set up as check boxes.
I want to be able to query for only those records
that match for whatever day of the week I input.
So for example out of 500 records, 15 of them
have "mon" "wed" "fri" checked, and I want to
know how many deliveries are scheduled for "fri",
15 records will show.
Tom
 
You were getting excellent advice from tina regarding your table structure
and normalization. I don't know why you didn't just stay there and listen.
If you can't change your table structure then someone in that thread would
tell you how to normalize your data with a union query and the search using
the union query as the base.
 
Back
Top