Checkbox in query

C

complex

Greetings to everyone!
My situation is this, my database creates a work order with some tasks, that
may or may not be accomplished. I have a query that retrieves the tasks
present on a selected work order, (those tasks come from a table called
taskstbl, and this table does not have a check box field), my objective is to
verify the tasks that appear on the results of that query, and check the
tasks that were accomplished and add (append query) them to the work order
record (something like workorderdetailstbl). So what I want to know is, can't
I add a check box "field" to the query so that the append query "knows" what
to add to the workorderdetailstbl? The check box would only have a temporary
utility...if I may call it like this. Is it really necessary to have the
check box field on the original table? Or can I just add the checkbox field
to the query as an expression?
 
A

akphidelt

It's best to add the checkbox field to the table. Then you can create a form
with a record source to that table and when the box is checked you don't have
to append anything. You can just query for the results. If you want items not
checked in the query criteria of the checkbox field just type in 0.
 
S

sam

I would have thought that if it were any kind of worthwhile workorder then
the tasks completed/incomplete should be tracked with at least a completion
date. This can then be used as criteria for any query of completed/incomplete
tasks on a particular work order
 
C

complex

First of all I would like to thank for both of the replies, since I have this
question on more than one forum and you were the first to give an opinion.
Passing on to the question, akphidelt, I understand your suggestion to use
the table directly, but my maind purpose is to "filter" (query) the tasks in
order do avoid any confusion to the user, so that we can avoid error, no
mistaken tasks selected as accomplished...so I really want this in a query
"shape". I think myself clear, but i'll give an example, in this specific
function we have maybe 70 or 80 diferent directives to do at different times,
and besides that there are components and even more things, and in a work
order usually we have maybe 30 items or sometimes even less, so you can see
how this query would simplify things.

About the date of completion as sam notices very well, its an important
(very important) question and I have it covered, as on the query the date of
creation of the work order is added to each item, and the closing date will
be added to each item on the work order close.

So and after writing a lot (maybe to much :) ) I would like to hear your
opinions.
Can't you suggest me a way to include the checkbox in the query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top