Filtering records in a query based on field values in adjacent records

#1 (**permalink**) 28-Jul-2006, 08:12 AM

I'm looking for a way to filter records in a query (or report) based on
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10352-filtering-records-query-based-field-values.html
a value in a field of an adjacent record. Can this be done easily? I
cannot find any info in the help files.

Thanks

*

#2 (**permalink**) 28-Jul-2006, 08:12 AM

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/kb/210504/en-us
for 2 approaches.

A third approach would be a subquery. If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10352
Reply to group, rather than allenbrowne at mvps dot org.

"sdisalvo" wrote in message
news:1148606072.982933.201610@i39g2000cwa.googlegr oups.com...
> I'm looking for a way to filter records in a query (or report) based on
> a value in a field of an adjacent record. Can this be done easily? I
> cannot find any info in the help files.
>
> Thanks

#3 (**permalink**) 28-Jul-2006, 08:12 AM

Thanks Allen,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10352

You pointed me in the right direction. I was able to get my report to
do exactly what I wanted it to do.