Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Yes / No Field on Query

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Yes / No Field on Query

Resolved · Urgent Priority · Version 2003

Reply Mon 21 Jul 2008, 15:09Delegate Lisa said...

Lisa has attended:
Excel VBA Intro Intermediate course

Yes / No Field on Query

When you have a Yes/No field in a table and you make a query from the data - how do you only have the "yes" ones show up?

For upcoming training course dates see: Pricing & availability

Reply Mon 21 Jul 2008, 16:46 Edited on Mon 21 Jul 2008, 16:49Trainer Pete said...

RE: Yes / No Field on Query

Hi Lisa,

Thank you for your post;

In a Form or Report consider the following, if for example you have the following fields: Taxable, Item Cost, Item quantity where Taxable is your yes/no field.

In the Detail section of the form I would create a textbox with the formula: IIf([Taxable]=-1,([Item_Cost]*[Quantity])*0,0) (note the change to -1 from 1) and call it say TaxableAmount.

-1 is a yes in an Access Database and 0 is a no.

Try that it should work, if not please come back, regards Pete

Reply Mon 21 Jul 2008, 16:56Delegate Lisa said...

RE: Yes / No Field on Query

Hi,

not sure i got that - so thought it better to give you my example?
I have a item which is either active or not (hence the yes no tick)
when a report is run how do i just get the "active ones" to be shown?

Thanks Pete

Reply Mon 21 Jul 2008, 16:55Trainer Stephen said...

RE: Yes / No Field on Query

Hi Lisa

Thank you for your question

You simply need to enter yes into the criteria field of your query designer, under the relevant column.

Alternatively, you can enter -1 or 0.

Regards

Stephen

Reply Mon 21 Jul 2008, 17:00Delegate Lisa said...

RE: Yes / No Field on Query

Thank you sooooo much...
:-)

Access articles

· So You Still Haven't Learned How To Use Access Yet?
· How To Create Combo Lookups In Microsoft Access
· Use Microsoft Access to manage your work/life balance
· Cheating With Access Templates
· What Is The Database Documenter And How Is It Used?

Please browse our web site to find out more about
microsoft+access+course and other Microsoft training courses.

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips