By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

Filter and sort a form

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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.

Nov 12 '05 #2

P: n/a
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.

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.