Re: Get Value from Next Record for this record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Duane Hookom (duanehookom_at_NO_SPAMhotmail.com)
Date: 02/11/04 

Date: Tue, 10 Feb 2004 19:20:57 -0600

This might be doable in a query. I doubt you can perform this in a report.
Since we know nothing about your data, we won't be of much help. 

-- 
Duane Hookom
MS Access MVP
"Bob P" <anonymous@discussions.microsoft.com> wrote in message
news:ddb701c3effb$e882ecb0$a001280a@phx.gbl...
> I want to color the background in the current text box
> based on the next records value for this text box.  How do
> I get that value?  I know how to handle the background.
>
> Thanks
>
> Bob
>

Relevant Pages

  • Re: Best way to import text file into existing table on a daily ba
    ... One is a title of the report and the second row are field names. ... "Ken Snell " wrote: ... permanent table -- although having them the same will allow the query design ... <MS ACCESS MVP> ...
    (microsoft.public.access.externaldata)
  • Re: Sort Multi Time Fields
    ... Ken Snell ... <MS ACCESS MVP> ... I do have the report sorting and grouping by ... Save the query. ...
    (microsoft.public.access.reports)
  • Re: Crosstab Report
    ... MS Access MVP ... some of the information you posted to the query and found it very useful. ... would like to choose the year the report starts. ... Specify the column names in the query's Column Headings ...
    (microsoft.public.access.reports)
  • Re: Sort Multi Time Fields
    ... <MS ACCESS MVP> ... When it sorts now, it sorts numerically (ex: ... I do have the report sorting and grouping by date ... Save the query. ...
    (microsoft.public.access.reports)
  • Re: Crosstab Report
    ... MS Access MVP ... I try to write the report my headings/totals crash. ... "Duane Hookom" wrote: ... some of the information you posted to the query and found it very ...
    (microsoft.public.access.reports)