Re: Get Value from Next Record for this record

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

Date: Tue, 10 Feb 2004 23:02:58 -0600

My previous post was a subtle nudge to get you to provide more information.
Consider sharing:
-table and field names
-some sample data
-what you would like to eventually display 

-- 
Duane Hookom
MS Access MVP
"Bob" <anonymous@discussions.microsoft.com> wrote in message
news:e6c101c3f04c$c4eaaa80$a501280a@phx.gbl...
>
> >-----Original Message-----
> >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
> >>
> >
> >
> >.
> >I want to compare the values in the same field of a
> report driven by a query - the current field and the same
> field in the next record.
>
> Bob

Relevant Pages

  • Re: 2nd try, left join
    ... Thank Bob. ... and it seems to loop forever and return results in the millions when the highest result doing the query on Pet column at a time is less then 15000. ... >> You're going to need to provide some sample data and desired results ... > quicker response by posting to the newsgroup. ...
    (microsoft.public.inetserver.asp.general)
  • Re: 2nd try, left join
    ... > Upon insertion to the verified table, ... > when the highest result doing the query on Pet column at a time is ... Am I correct that given the sample data, ... Bob Barrows ...
    (microsoft.public.inetserver.asp.general)
  • Re: Totals Query Help!
    ... It'll help us if you can post some sample data, and show us what type of ... Ken Snell ... <MS ACCESS MVP> ... What I'm trying to do is write a query that will give me an average Value ...
    (microsoft.public.access.queries)
  • Re: Limit query to one result
    ... So I assume you have to do this in SQL, not in the query wizard. ... say the meeting has passed and the next meeting is ... Access MVP 2002-2005, 2007-2008 ... never hurts to provide a few rows of sample data (relevant fields only, ...
    (microsoft.public.access.queries)
  • Re: Get Value from Next Record for this record
    ... This might be doable in a query. ... I doubt you can perform this in a report. ... MS Access MVP ... "Bob P" wrote in message ...
    (microsoft.public.access.reports)