I am sorry about my vague question. I was running late yesterday and
did not include everything. I do know how to use filters but I need it
to be more userfriendly then that. I have ppl that never used access
before and they need to just make selections. For example user one
might need to get all the planner 011 and planner 023 that bought
product abc.
Thanks,
"Dennys G." <gi******@adelphia.net> wrote in message news:<OP********************@news3.news.adelphia.n et>...
Get acquainted with the built-in filter-by-form capabilities in MS Access.
There is a filter-by-form button on your toolbar. Do a search in the Access
help files under "Create a filter" to find out how to use this fine
capability.
Denny G.
"Sanders" <el**************@hotmail.com> wrote in message
news:ad**************************@posting.google.c om... I inherited an Access database and I have not worked with Access for
very long. I have a Form that goes through a bunch of different
queries until it spits out a datasheet with all kinds of information
from different tables, calculated fields etc. I need to filter the
data by workers projects and then sort the remainding data. I am not
sure if I can do this in the query to the data sheet or if I have to
update the form. I think the prettiest thing would be to update the
form right now I press the button and I get all the information in the
datasheet. I really would appreciate all the help that I can get as
nobody else in my office knows Access.