[AccessD] Exact reports are such a pita

I agree.  I don't think the idea of a temp table is over the top.  That's 
how I would do it.

Regards
Steve

-----Original Message----- 
From: Rocky Smolin
Sent: Wednesday, April 20, 2011 6:45 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Exact reports are such a pita

Personally I find temp tables to be quick, convenient, effective and the
easiest way to set up a complex report.

I suppose you could set those fields up with an iif source that fills in the
data if the data field is not null, or puts in the underscore, etc., if
null.



Rocky


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of jwcolby
Sent: Tuesday, April 19, 2011 11:26 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Exact reports are such a pita

I need to build a report that looks as close as possible to a state form.
This includes a couple of subforms which look like:

1) From:_____________ To:___________
2) From:_____________ To:___________
3) From:_____________ To:___________

And if I don't have a line 2 or line 3 I still need to fake it, put in the
number and underline.

IOW it should be indistinguishable from a copy of their form casually
compared side by side.

Can you say PITA.

The only thing I can think of is to build a temp table, place the 1) 2) and
3) in three records
(programmatically) and then fill in each record as needed.

That seems rather over the top.  Any suggestions for easy ways to fake this?