Query issues

[sk88]

I have a query which is based from two different tables. The first table consists of Customer personal information and the second table contains information on customer returns. Each return has its own unique identifier/ID
How do I set up in such a way that query will only pull like the first return of that customer? What rule/criteria should I give in my query to perform like that.



I would like the customer name, ID to show only one time and with the first return problem. Do I filter the Customer ID to make it unique?

I hope I made some sense :S

Thank you

[pbaldy]

See if this works for you, with a little adapting:

http://www.baldyweb.com/LastValue.htm

[sk88]

See if this works for you, with a little adapting:

http://www.baldyweb.com/LastValue.htm

PERFECT! That was an excellent site.

Thank you pbaldy!

[pbaldy]

Excellent! Glad it helped you.