Re: Query Based On "yes/no" Switch in Data Base Table

Tech-Archive recommends: Speed Up your PC by fixing your registry

so you have seven fields in the table, named "Sunday", "Monday", "Tuesday",
etc - each with a data type of Yes/No? if so, the first thing i'd do is
normalize the table to one field for the day of the week, and store the day
value (as a number 1-7, or as text) in it. if you have a Date/Time field in
the table, and the date values correspond to the days of the week that are
being stored, then you don't need the "day" field at all because you can
extract the day of week from the date value.

hth


"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:173E0343-4E8D-474C-B224-3B79C9DADC4E@xxxxxxxxxxxxxxxx
Tina,
Correction. It is a "yes/no" on the "data type" in the table.
On my form, it is a "check box"
Tom

"tina" wrote:

how is the day of the week stored in the *table*? as a text value "
Sunday",
"Monday", etc? or as a date value from which the day of the week can be
extracted? or...?

hth


"Tom" <Tom@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8CA83687-6D6C-483C-A266-1147BFF53F17@xxxxxxxxxxxxxxxx
I have on my Form the following:
Sunday "yes/no"
Monday "yes/no"
Tuesday "yes/no"
Wednesday "yes/no"
Thursday "yes/no"
Friday "yes/no"
Saturday "yes/no"
The "yes/no" is in the form of a "check box"
I'd like to design a query that will list only the
day I choose, if it is "checked".
i.e. If I have 500 records, and only 1 record has
Friday checked, then when I query for Friday, Voila!
How do I do this?
Tom





.

Relevant Pages

  • Re: Query Based On "yes/no" Switch in Data Base Table
    ... This is a delivery schedule ... extract the day of week from the date value. ... Friday checked, then when I query for Friday, Voila! ...
    (microsoft.public.access.gettingstarted)
  • Re: Find Specific Record in database Table via VB code
    ... intSearchAtty had been defined as DIM intSearchAtty As Integer and then using ... Programmer Analyst II ... I've attempted to use a macro calling a query to ... >> I'm not sure if I need to use a query to get the record, then extract ...
    (microsoft.public.access.formscoding)
  • Re: MDX very slow
    ... from what I understand, you query your cube to extract all the content of the cube, including leaf level and aggregated content into a CSV file... ... there is a lot of text to extract + a lot a calculations to do. ... I think your users will load this file into another database, so send them only the detailed content and they aggregate as they need, and sending the detail is easy to do with a simple SQL query into your source database. ... > Would it help if I add more aggregations to the cube? ...
    (microsoft.public.sqlserver.olap)
  • Re: Extracting data from web page with an imbedded DB query
    ... I suspect this from the URL in the DB query to get the data. ... my Excel query is no longer able to extract the data ... Is there a way to get Excel to look at the final page and then extract ... I believe that Excel only looks at the HTML, ...
    (microsoft.public.excel.programming)
  • RE: How to Extract the last 90 days of information for a record
    ... Assuming that we need to extract the last 30 ran hours ... to create a Procedure, Query, DTS to create this I'll test the performance on ... I have Visual Basic program for that; ... > have query that order the records by part number and in descending order by ...
    (microsoft.public.sqlserver.server)