adding a checkbox field to a QUERY

Question

I have a table with the fields Code and Description.

I am trying to make a query ( to use on a form) that in the query there is a 3rd column for "attic Storage included" with a check-box for yes or no answers.

The purpose of this is, on the form, the estimator, when estimating a bid will select multiple individual rows of components in the bid.

 for example, the company installs window treatments like blinds and shades on a commercial scale( no residential). When the estimator goes to the site to propose a bid,  its not a simple case of  just blinds, or shades...  the client may want  Motorized blinds with shade pockets and some Vinyl blinds.

Here is the table of all the things that can be selected: ( one or more)

forgive the formatting.. It doesn't want to paste right.

In addition to being able to select  say..  motorized shades,  Shade Pocket, Vinyl blinds ( or more), there needs to be FOR EACH ITEM they selected the option to include attic storage.. not this is not stored in any table in the database. it is merely show on the form, really just for printing purposes.  so when they submit the bid paperwork to the company contact,  it shows in writing the scope of the estimate.

1	General Costs
1000	Manual Shades
1001	Motorized Shades
1002	Shade Pocket
1003	Electrical and Controls
1004	Aluminum Blinds
1005	Vinyl Blinds
1006	Vinyl Plus Blinds
1007	Faux Wood Blinds
1008	Bass Wood Blinds
1009	Vertical Blinds
1011	Light Louvers
1012	Plantation Shutters
1013	Cubicle Curtains
1014	Draperies
1015	Misc
1016	Repairs
1017	Warranty
1018	Enclosures

their current form does not have any of this. all it has is a text box labeled " Bidding on:" and they type in  "Blinds" or "Shades"  so currently they have no way to indicate the details of what the estimate actually includes.  

the want it so that  if they go in and make a bid based on manual shades, but the installers get there and the client says " no.. I wanted  motorized shades and an enclosure.... well the want to be able to go in there and be like " no.. it says right here the bid was for  manual shades and no enclosures so it will be more money"

Answer 1

I recommend you add the check field to the table, it will be cleaner and you can reference to it in the future,

The form will keep track of only one variable and will check or un-check all rows at when you click on one line

Answer 2

As phrased, You Can't Get There From Here.

A query is nothing other than a view of data stored in a table, or calculcated from values stored in a table, or non-record related constants (such as references to a form). If you want a yes/no field associated with each row in a dataset you must - no option!

• store that yes/no field in a Table.

It could be the table containing your code and description, or it could be in a related table (for example, one linking the table of items to the table of clients so you could have each client checking a different set of boxes) - but it simply MUST be in a Table.