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

Query-Generated report

P: n/a
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in form
view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies

P: n/a
As long as your query will always have the same fields, you can base your
report on that instead of a table.

You can also execute a make-table query, which will create a new table with
the results of the query.
"Generate a set of records in form view" does not seem to describe very
accurately anything I know of in Access.

Perhaps you could be a little more explicit about what it is you're trying
to achieve?

- Turtle

"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in form view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce

Nov 12 '05 #2

P: n/a
Are you asking how to filter a report?

Every report is based on a table or query. The dynamic part is the filter. Yesterday
I posted a link to a sample report filter app. Here it is again.

http://www.amazecreations.com/datafa...portFilter.zip

--

Danny J. Lesandrini
dl*********@hotmail.com
http://amazecreations.com/datafast
"B Love" <bl*******@charter.net> wrote ...
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in form
view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce

Nov 12 '05 #3

P: n/a
Let me be a little more specific about what I am asking. I currently have a
form with which the user can enter one of several criteria which is then
used to query a table. This performs nicely right now. As an example, The
user can enter an author, a subject from a dropdown list, a date range, or a
specific item number, and a dynaset is generated which shows all the records
matching the criteria. Personally, that is good enough for me, but the
end-user is very PC-illiterate, and does not like to scroll to see the
entire record. He is an 81 year-old and uses this database to keep track of
his manuscript and art collection. Ideally, I would like some means to
display the results of this search so that he won't have to scroll and
adjust column widths, etc. (that is a nightmare to watch). If the results
(which ALWAYS contain the same fields) can be saved in a temporary report
(just for viewing) that would satisfy the situation. The make-table query
described by turtle has possibilities. One field that is returned by the
query is a hyperlink field, which I realize would not have any real use in a
report, and that is why I was wondering about a temporary set of records
displayed as a result of the query, so that the hyperlink field could be
clicked and the viewer taken to the web page containing the art. THAT would
be ideal, but I feel that is impossible without getting into ASP. The
report will be adequate if that is possible.

I hope I have described my needs ok. I will check out the responses to your
answers. I think they are giving me hope of doing what I am trying to do.

Thanks again!!!
Bruce

"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in form view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce

Nov 12 '05 #4

P: n/a
See the description updated below in brackets [ ]

"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
Let me be a little more specific about what I am asking. I currently have a form with which the user can enter one of several criteria which is then
used to query a table. This performs nicely right now. As an example, The user can enter an author, a subject from a dropdown list, a date range, or a specific item number, and a dynaset is generated which shows all the records matching the criteria. Personally, that is good enough for me, but the
end-user is very PC-illiterate, and does not like to scroll to see the
entire record. He is an 81 year-old and uses this database to keep track of his manuscript and art collection. Ideally, I would like some means to
display the results of this search so that he won't have to scroll and
adjust column widths, etc. (that is a nightmare to watch). If the results
(which ALWAYS contain the same fields) can be saved in a temporary report
(just for viewing) that would satisfy the situation. The make-table query
described by turtle has possibilities. One field that is returned by the
query is a hyperlink field, which I realize would not have any real use in a report, and that is why I was wondering about a temporary set of records
displayed [IN A FORM] as a result of the query, so that the hyperlink field could be clicked and the viewer taken to the web page containing the art. THAT would be ideal, but I feel that is impossible without getting into ASP. The
report will be adequate if that is possible.

I hope I have described my needs ok. I will check out the responses to your answers. I think they are giving me hope of doing what I am trying to do.

Thanks again!!!
Bruce

"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
I am wondering if I can have a dynamically generated report based upon the results of a query (in Access2000). Any ideas? Related to that (if that cannot be done) can the output of a query generate a set of records in

form
view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce


Nov 12 '05 #5

P: n/a
Just base your report of form on the query and the query results wull come out.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in form
view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce

Nov 12 '05 #6

P: n/a
B Love wrote:
Let me be a little more specific about what I am asking. I currently have a
form with which the user can enter one of several criteria which is then
used to query a table. This performs nicely right now. As an example, The
user can enter an author, a subject from a dropdown list, a date range, or a
specific item number, and a dynaset is generated which shows all the records
matching the criteria. Personally, that is good enough for me, but the
end-user is very PC-illiterate, and does not like to scroll to see the
entire record.
Instead of a datasheet, have you considered making a form a continuous form?.
That way you can display t 1 or many rows per record instead of 1 line per
record. If the filter returns many records, he will have to scroll vertically
but at least can see a full record.

You might want to open the form maximized also.

He is an 81 year-old and uses this database to keep track of
his manuscript and art collection. Ideally, I would like some means to
display the results of this search so that he won't have to scroll and
adjust column widths, etc. (that is a nightmare to watch). If the results
(which ALWAYS contain the same fields) can be saved in a temporary report
(just for viewing) that would satisfy the situation. The make-table query
described by turtle has possibilities. One field that is returned by the
query is a hyperlink field, which I realize would not have any real use in a
report, and that is why I was wondering about a temporary set of records
displayed as a result of the query, so that the hyperlink field could be
clicked and the viewer taken to the web page containing the art. THAT would
be ideal, but I feel that is impossible without getting into ASP. The
report will be adequate if that is possible.

I hope I have described my needs ok. I will check out the responses to your
answers. I think they are giving me hope of doing what I am trying to do.

Thanks again!!!
Bruce

"B Love" <bl*******@charter.net> wrote in message
news:vu************@corp.supernews.com...
I am wondering if I can have a dynamically generated report based upon the
results of a query (in Access2000). Any ideas? Related to that (if that
cannot be done) can the output of a query generate a set of records in

form
view. ( The second request sounds even more impossible to the first!) .
Thanks for any insight you can share with me!

~Bruce


Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.