G
Guest
HOw do I create aQuery that selects all records with a box
that is checked
that is checked
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
Tom Ellison
Dear ???:
You cannot. Queries return values in text boxes. If you want to use
check boxes, combo boxes, list boxes, display pictures, etc. you will
have to use a form. Forms give you this power to design and lay out
what you want.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
You cannot. Queries return values in text boxes. If you want to use
check boxes, combo boxes, list boxes, display pictures, etc. you will
have to use a form. Forms give you this power to design and lay out
what you want.
Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
M
MSN
what is best way to set up table for query with field that when fillled in I
can move recoed to archive. These are to be moved when bill is paid. i now
have a check box "Paid"
Thanks John Prange
can move recoed to archive. These are to be moved when bill is paid. i now
have a check box "Paid"
Thanks John Prange
J
Jeff Boyce
John
By attaching your post to the previous thread, you've effectively
buried/hidden your question. Next time, start a thread of your own to get
more folks considering it.
Why do you feel it necessary to "move" a record? This is (potentially) a
rhetorical question. Usually folks want "historical" or "archive" records
not to clutter up their active forms. This is very easy to do, and does NOT
require moving records from one table to another.
Add a Yes/No-type field for "Archived" in the table in question. When a row
is archived, check the field (i.e., set to "yes"). Modify your current
queries to only return those rows where Archived <> Yes.
If you have so many records that you feel it necessary to remove rows (and
we're talking in the millions), you should start considering a database with
more horsepower.
By attaching your post to the previous thread, you've effectively
buried/hidden your question. Next time, start a thread of your own to get
more folks considering it.
Why do you feel it necessary to "move" a record? This is (potentially) a
rhetorical question. Usually folks want "historical" or "archive" records
not to clutter up their active forms. This is very easy to do, and does NOT
require moving records from one table to another.
Add a Yes/No-type field for "Archived" in the table in question. When a row
is archived, check the field (i.e., set to "yes"). Modify your current
queries to only return those rows where Archived <> Yes.
If you have so many records that you feel it necessary to remove rows (and
we're talking in the millions), you should start considering a database with
more horsepower.