Same report with two data sets

[Leslie Isaacs]

Hello All

I have a table [applicants] which has amongst its fields 'referee1_title',
'referee1_fname', 'referee1_lastname' and also 'referee2_title',
'referee2_fname', 'referee2_lastname'. I want a single button that will
preview a single report, twice, such that both are viewable on screen at the
same time: once with the 'ref1' details and once with the 'ref2' details.

I had intended to do this by having an unbound yes/no field on the form, the
value of which is reversed when the report is first previewed, and which the
query behind the report uses to determine whether to use the 'ref1' details
or the 'ref2' details. The only problem is that once open in preview (with
the 'ref1' details), the report does not open again to display the 'ref2'
version.

I realise that perhaps the 'ref1' and 'ref2' data should perhaps be in a
separate table, and also that - even with the above data structure - I could
simply print the report directly instead of previewing it (in which case I
think the 1st version would close after printing and so the 2nd version
would then open and print). But changing the data structure would be a
bigger job than I've got time for, and I do need to preview the report
before printing - ideally without having to manually select one version then
the other.

Hope someone can help.
Many thanks
Leslie Isaacs

 

[strive4peace]

Hi Leslie,

Changing the data structure is EXACTLY what you need to do.
It will take a lot less time to convert the data than it
will to continue working with it as it is -- not to mention,
you will just compound your problems as you go along.

Do you know how to use Append Queries? look here:

news://msnews.microsoft.com:119/[email protected]

Whenever you find yourself putting numbers into fieldnames,
you should ask yourself if you shouldn't perhaps set up a
seperate table.

In the related table with the referee information, you can
have a RefNum field with 1 or 2 or whatever number the ref
is -- then it is a very simple matter to change the report
to use another set of data.

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

 

[strive4peace]

Hi Leslie,

the link I gave you is not valid, look here:

http://www.microsoft.com/office/com...orms&tid=03dd204d-5762-4529-a321-fb440892ce71

read the post that has "Don't let the SQL acronym intimidate
you, it is not tough to learn the basics. " at the beginning

Since all queries are SQL statements, becoming familar with
SQL will carry you a long way...

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Hi Leslie,

Changing the data structure is EXACTLY what you need to do. It will
take a lot less time to convert the data than it will to continue
working with it as it is -- not to mention, you will just compound your
problems as you go along.

Do you know how to use Append Queries? look here:

news://msnews.microsoft.com:119/[email protected]

Whenever you find yourself putting numbers into fieldnames, you should
ask yourself if you shouldn't perhaps set up a seperate table.

In the related table with the referee information, you can have a RefNum
field with 1 or 2 or whatever number the ref is -- then it is a very
simple matter to change the report to use another set of data.

Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day

remote programming and training
strive4peace2006 at yahoo.com

*

Hello All

I have a table [applicants] which has amongst its fields
'referee1_title', 'referee1_fname', 'referee1_lastname' and also
'referee2_title', 'referee2_fname', 'referee2_lastname'. I want a
single button that will preview a single report, twice, such that both
are viewable on screen at the same time: once with the 'ref1' details
and once with the 'ref2' details.

I had intended to do this by having an unbound yes/no field on the
form, the value of which is reversed when the report is first
previewed, and which the query behind the report uses to determine
whether to use the 'ref1' details or the 'ref2' details. The only
problem is that once open in preview (with the 'ref1' details), the
report does not open again to display the 'ref2' version.

I realise that perhaps the 'ref1' and 'ref2' data should perhaps be in
a separate table, and also that - even with the above data structure -
I could simply print the report directly instead of previewing it (in
which case I think the 1st version would close after printing and so
the 2nd version would then open and print). But changing the data
structure would be a bigger job than I've got time for, and I do need
to preview the report before printing - ideally without having to
manually select one version then the other.

Hope someone can help.
Many thanks
Leslie Isaacs