Query-Generated report

[B Love]

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

[MacDermott]

Re: Query-Generated report

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" <blove2651@char ter.net> wrote in message
news:vuge66c4pn lv7b@corp.super news.com...[color=blue]
> 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[/color]
form[color=blue]
> view. ( The second request sounds even more impossible to the first!) .
> Thanks for any insight you can share with me!
>
> ~Bruce
>
>[/color]

[Danny J. Lesandrini]

Re: Query-Generated report

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/datafast/GetFile.aspx?file=A2KReportFilter.zip

--

Danny J. Lesandrini
dlesandrini@hot mail.com

http://amazecreations.com/datafast

"B Love" <blove2651@char ter.net> wrote ...[color=blue]
> 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
>
>[/color]

[B Love]

Re: Query-Generated report

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" <blove2651@char ter.net> wrote in message
news:vuge66c4pn lv7b@corp.super news.com...[color=blue]
> 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[/color]
form[color=blue]
> view. ( The second request sounds even more impossible to the first!) .
> Thanks for any insight you can share with me!
>
> ~Bruce
>
>[/color]

[B Love]

Re: Query-Generated report

See the description updated below in brackets [ ]

"B Love" <blove2651@char ter.net> wrote in message
news:vugkvpgaok 5e55@corp.super news.com...[color=blue]
> Let me be a little more specific about what I am asking. I currently have[/color]
a[color=blue]
> 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,[/color]
The[color=blue]
> user can enter an author, a subject from a dropdown list, a date range, or[/color]
a[color=blue]
> specific item number, and a dynaset is generated which shows all the[/color]
records[color=blue]
> 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[/color]
of[color=blue]
> 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[/color]
a[color=blue]
> 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[/color]
field could be[color=blue]
> clicked and the viewer taken to the web page containing the art. THAT[/color]
would[color=blue]
> 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[/color]
your[color=blue]
> answers. I think they are giving me hope of doing what I am trying to do.
>
> Thanks again!!!
> Bruce
>
> "B Love" <blove2651@char ter.net> wrote in message
> news:vuge66c4pn lv7b@corp.super news.com...[color=green]
> > I am wondering if I can have a dynamically generated report based upon[/color][/color]
the[color=blue][color=green]
> > results of a query (in Access2000). Any ideas? Related to that (if[/color][/color]
that[color=blue][color=green]
> > cannot be done) can the output of a query generate a set of records in[/color]
> form[color=green]
> > view. ( The second request sounds even more impossible to the first!) .
> > Thanks for any insight you can share with me!
> >
> > ~Bruce
> >
> >[/color]
>
>[/color]

[PC Datasheet]

Re: Query-Generated report

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
resource@pcdata sheet.com

https://www.pcdatasheet.com

"B Love" <blove2651@char ter.net> wrote in message
news:vuge66c4pn lv7b@corp.super news.com...[color=blue]
> 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
>
>[/color]

[Salad]

Re: Query-Generated report

B Love wrote:
[color=blue]
> 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.[/color]

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.

[color=blue]
> 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" <blove2651@char ter.net> wrote in message
> news:vuge66c4pn lv7b@corp.super news.com...[color=green]
> > 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[/color]
> form[color=green]
> > view. ( The second request sounds even more impossible to the first!) .
> > Thanks for any insight you can share with me!
> >
> > ~Bruce
> >
> >[/color][/color]