This may sound easy to some of the expert advice on this forum but I am lost. As you probably heard before for those who see my postings. I have a database that tracks youths. What I am trying to do is have a enter parameter in a form that will give the values for which youth has completed a goal or an activity. Right now the tables are set up as: Main (name, address, etc... with SSN# as primary key and linked to Tables--Goal and Activity (which only have SSN# and a field name goal or activity in it) The field is set up with a yes or no box. I want to be able to type yes or no in the parameter box and get all the goals that are marked "yes" and the same for activity. I hope I have not lost everyone. Any help with this will be greatly appreciated.
Running Query to get yes or no
- Thread starter VWilson39
- Start date
RichMorrison
Registered User.
- Local time
- Today, 16:14
- Joined
- Apr 24, 2002
- Messages
- 588
When you create a "yes/no" field in a table, the stored value is actually numeric. Yes and No or True and False are just what is displayed.
On a form, you need something that translates to the equivalent numeric value. False is zero and True is negative 1.
HTH,
RihM
On a form, you need something that translates to the equivalent numeric value. False is zero and True is negative 1.
HTH,
RihM
