Use multi checkbox value for make table query criteria

[alicezyk]

Hello All!
I am new to access forms.
I am trying to use the 2 checkboxs for my make table query.
Future cost checkbox and marginal cost checkbox.
If future cost is checked, then I want 00 as criteria for the field cost type in the query, if marginal is checked then 01. If both checked, then I want both.

Seems like a iif statement is not working in my query. I am trying to create an event now but I do not understand the VB codes..

Maybe I can use multi selection instead of checkbox?

Any help will be appreciated!

Thanks!

[zmbd]

there are a few ways of doing this; however, let's start with your query.

open in design view
right click in the show tables area
select "SQL View"

You'll get a lot text (^_^)

Come back here,
cut and paste that text in the box
select the text
click on the [CODE/] formatting button in the toolbar.

then give us a second to take a look

(^_^)