There are lots of ways to filter data in reports, but you don't provide enough information to help you.
It would also be nice to know your name. And you should start a new topic if you want to ask a question about something else.
John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
(Paris, France)
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of mahinalanibaker@yahoo.com
Sent: Tuesday, September 10, 2013 11:59 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] RE: Help with Yes/No boxes
How do I get it to filter the information into my reports. I don't see it in my query anywhere.
--- In ms_access_professionals@yahoogroups.com, <duanehookom@...> wrote:
Make sure the control wizard is turned on and drop an option group onto your form. You can pick a style to display buttons or check boxes. The Option Group control will have a value based on which option is selected. Each option has its own numeric value.
Duane Hookom MVP
MS Access
________________________________
> From: mahinalanibaker@...
>
> Yes I use the form to filter for my report. How would I do an option
> group? I'm sorry I'm just super new to access and I'm trying to figure
> it out.
>
> Thanks
> --- In ms_access_professionals@yahoogroups.com, <duanehookom@...> wrote:
>
> Is the form bound to a table or used for filtering a recordset? If
> there is only one option that should be selected, the standard solution
> is to use an Option Group.
>
> If you have separate fields for day and night, consider changing to a
> single "time of day" or "shift" field.
>
> Duane Hookom MVP
> MS Access
>
> ________________________________
>> From: mahinalanibaker@...
>>
>> I have a form with a few yes/no boxes. One option is day and the other
>> is night. If a user clicks on day is there a way for the night box to
>> become unavailable to select. Obviously if a job is completed in the
>> day it can't be completed at night. I think that a tool like this will
>> help eliminate data errors in my reports. Is soemthing like this
>> possible?
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (7) |
Tidak ada komentar:
Posting Komentar