Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Goto Record in Select Expert?

Status
Not open for further replies.

justsomeguy

Technical User
Joined
Aug 6, 2001
Messages
4
Location
US
Here is the situation. I have a report with two different tables attached. I'm trying to get one field to determine which records will show up, which the way it is in the field/table will be the "last record". How do I use select expert or select records to do this. Specifically, what is the formula I should be using?

Thanks,
BamaBoy
 
A Record Selection Formula like
{SomeTable.Colour} = 'Red'
will get you the red records. The number of different tables isn't an issue. I'm not sure what you mean by your last record reference - the order of the records is not defined by the record selection formula. Malcolm Wynden
Authorized Crystal Engineer
malcolm@wynden.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top