Re: Layout Preview drops criteria

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Duane Hookom (duanehookom_at_NoSpamHotmail.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 13:07:35 -0500

I doubt this is possible. The Layout Preview is just a layout preview and
does not apply any criteria. If it did apply criteria, I'm afraid you would
be back to the "takes several minutes to generate". 

-- 
Duane Hookom
MS Access MVP
--
"Karla V" <KarlaV@discussions.microsoft.com> wrote in message
news:E2FD4B47-ED60-4151-AA05-254ECF7E7BD9@microsoft.com...
> A co-worker and I are designing a very large report.  It takes several
minutes to generate Print preview.  So, to speed things up, we are using
Layout Preview instead of Print Preview.  However, when we choose Layout
Preview, it drops all of the set criteria.  For example, the query is set to
pull only personnel at a certain location, but in Layout Preview, ALL
personnel show up regardless of location.
>
> Is there any way to include the actual data instead of sample data?
>
> Thanks!

Relevant Pages

  • Re: Showing a Set in a Layout
    ... Buckbuck wrote: ... criteria, Retailers for example. ... enter the Layout through a Script to effect a Find function. ... You have to perform, or script, a Find. ...
    (comp.databases.filemaker)
  • Re: Count distinct based on criteria
    ... criteria values are in B1:B4. ... in rows and values in columns - sales reps. ... I'm no sure what you mean by columns layout? ... A pivot table is almost what I need, ...
    (microsoft.public.excel.worksheet.functions)
  • Re: organization
    ... If such a layout change were to happen I think the least time wasting ... - issue a request for new layout propositions ... No consensus, no change. ... > weird criteria to use? ...
    (freebsd-hackers)
  • Re: Conditional sum matching two columns and a row
    ... "Biff" wrote: ... The sample formulas are based on 3 criteria: ... entering some code in the criteria cells but I don't know what all your ... This can be done based on your current layout but it is extremely ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Conditional sum matching two columns and a row
    ... "Biff" wrote: ... The sample formulas are based on 3 criteria: ... entering some code in the criteria cells but I don't know what all your ... This can be done based on your current layout but it is extremely ...
    (microsoft.public.excel.worksheet.functions)