 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / June 2006HELP - Please see Last post on 6/16/06
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?  SignatureWayne Morgan MS Access MVP > 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 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 > Tom, I don't see the post you mention. Something must have happened to it, > will you please give me more information? [quoted text clipped - 5 lines] > > time crunch. > > 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. SignatureDuane Hookom MS Access MVP > Wayne, > I have a table that is for Deliveries. [quoted text clipped - 22 lines] >> > time crunch. >> > Tom Ok, the original post finally showed up in OE. I've answered there. SignatureWayne Morgan MS Access MVP > Wayne, > I have a table that is for Deliveries. [quoted text clipped - 22 lines] >> > time crunch. >> > Tom |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.