PC Review


Reply
Thread Tools Rate Thread

Report based on selections on a form

 
 
=?Utf-8?B?VFQ=?=
Guest
Posts: n/a
 
      27th May 2005
I have a form that has about 80 items each one has an option group for yes,
no, and N/A. This updates a table for each itme for each person. Now I have
a form for the user to create a report, but gives the user options to narrow
the criteria for the report, like date, section, etc.

I could create a report for every possiblity the user can select, but I
would rather have one report and build in a statement to populate the report.

The report shows these 80 items in a column and 3 boxes next to each item to
display the count of yes, no, and N/A. I am trying to get an overall count
for every record base on the criteria the user selected to create the report.
I can't use the recordsource because it gives me a report for each record.
I tried using a crosstab query, but that didn't seem to help. So for each of
these boxes I created a formula to count each item. However, since I want to
use one report to display the information based on the user selection from
the form I am stuck on how to do this. I thought about creating a temp table
and delete the items before previewing the report then populate it with all
records with the possibility of narrow it down by the user selection.

I hope I am making sense here.

How can I excute a query "append query" based on a strSQL string? This will
populate my temp table. I can then base the formula for each box on each
itme in this table.

Any help or other ideas on how to do this would be appreciated,
 
Reply With Quote
 
 
 
 
David Lloyd
Guest
Posts: n/a
 
      29th May 2005
I am not sure I understand all the details of your report, but one
suggestion I would make would be to look at using the DCount function. This
function allows you to count the number of items in a table or query
separate from the report Record Source. The DCount function also allows you
to specify criteria to limit the records included in the count.

If the user inputs from the form are not shown visibly on the form, then you
can consider using hidden textboxes to reference there values on the report
and in the DCount function.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


"TT" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
I have a form that has about 80 items each one has an option group for yes,
no, and N/A. This updates a table for each itme for each person. Now I
have
a form for the user to create a report, but gives the user options to narrow
the criteria for the report, like date, section, etc.

I could create a report for every possiblity the user can select, but I
would rather have one report and build in a statement to populate the
report.

The report shows these 80 items in a column and 3 boxes next to each item to
display the count of yes, no, and N/A. I am trying to get an overall count
for every record base on the criteria the user selected to create the
report.
I can't use the recordsource because it gives me a report for each record.
I tried using a crosstab query, but that didn't seem to help. So for each
of
these boxes I created a formula to count each item. However, since I want
to
use one report to display the information based on the user selection from
the form I am stuck on how to do this. I thought about creating a temp
table
and delete the items before previewing the report then populate it with all
records with the possibility of narrow it down by the user selection.

I hope I am making sense here.

How can I excute a query "append query" based on a strSQL string? This will
populate my temp table. I can then base the formula for each box on each
itme in this table.

Any help or other ideas on how to do this would be appreciated,


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
HOW do I make selections and carry only those selections thru proc kealaz Microsoft Access Database Table Design 5 5th Feb 2009 05:37 AM
HOW do I make selections and carry only those selections thru proc kealaz Microsoft Access 1 5th Feb 2009 03:35 AM
Start Menu selections and Graphical Button selections Pat Windows XP Performance 0 15th Jun 2004 05:52 PM
Report query based on form selections Bill Taylor Microsoft Access Queries 3 6th May 2004 12:24 PM
Multiple default printer selections, automatic selections? Eric Windows XP Print / Fax 0 30th Dec 2003 03:48 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:37 PM.