Re: Subreport or DLookup?

Thanks for your response, Rick. However, if I I was performing a task that
required one or the other, I wouldn't be asking this question. As I said in
the initial post, I have multiple controls coming from different tables
linked by a common field. Maybe I wasn't clear though about how only 1 row
of data from the sub-tables per report is being accessed, but anywhere from
5 to 12 controls (fields) per table is being used per report page. And,
I've got 5 subreports (hitting on 5 separate tables via queries) doing all
this. So, would it be faster to continue using this method, or would it
behoove me to rewrite stuff to do lots of dlookups instead--that's my
dilemma. Or, would even sub-queries be faster?

I'll experiment. But, again, thanks for your response Rick,
ron


"Rick Wannall" <wannall@xxxxxxxxxxxxx> wrote in message
news:MUhfg.36426$4L1.4689@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
More important to your question is the fact that DLookup and subreports
are
not substitutes for each other. If you have multiple rows of related data
to display, you're going to have to use a subreport.

Example: A customer can have many orders (order headers). An order
header
can have many details (order lines).

If you want to print a customer and then a list of his orders, you must
use
a subreport. There is no way with dlookup() to generate the multiple
linesyou would need to represent each of the lower level (order header)
records.

If this is similar to your task, the relative speed of dlookup and
subreports is not relevant.


.

Relevant Pages

  • Re: Date>record association
    ... > I opened the mail to see a useful response. ... Could be previous posting didn't get any help. ... Who knows maybe old Rick B will be helpful to you some day. ... I have tried the multiple posting by listing groups in the cc ...
    (microsoft.public.access.forms)
  • Re: Snakeing Sub Report
    ... The demo file at the following link might help: ... Its simplified as it was produced purely in response to a reader's enquiry to ... The file includes both a single report and a subreport solution. ...
    (microsoft.public.access.gettingstarted)
  • Re: Copying a button and precedure in Access 97
    ... Rick, I do understand, and I too apologize for being so quick to take offense. ... Thanks for clarifying you response. ... feature to allow Copy and Paste Controls with Code, ...
    (microsoft.public.access.formscoding)
  • Re: Serial comma delimited text - Import to XL evry 8th comma nuRo
    ... I sent you an off-line response about the "one off" problem. ... the problem was that some of the records were separated from the rest by 3 commas whereas others were separated from the rest by 2 commas. ... To make the file ask for the filename rather than hard coding it in, first declare a variable... ... Rick ...
    (microsoft.public.excel.programming)
  • Re: Newbie type "What ifs"
    ... I had also been reading that to realize an arbitrarily shaped frequency response yo Fourier Transform it to get the required impulse response. ... To what does "real IQ filters" refer. ... I don't find any thing in index of either rick Lyons' or Steve Smith's books. ...
    (comp.dsp)