Filtering

[alexriverajr]

I'm trying to create an expression that filters out records based upon a selection in another column. Im kind of lost on where to start. Just an example of what thinking:

Selection from row a filters a number of records that meet that selection.

Hope this illustrates what I'm trying to achieve.

Thanks in advance.

 

[neileg]

Sound like you need a simple select query with a criterion. Probably best done with a combo box on a form for the user to select the value they want.

 

[alexriverajr]

I have tried this:

=DLookup("[FirstName] & ' ' & [LastName]", "Guest", "GuestNo =
'" & [Reservations.GuestNo] & "'")

But I get a mismatch error. Is there something glaringly wrong with this. Thanks

 

[georgedwilkinson]

Try:

=DLookup("[FirstName] & ' ' & [LastName]", "Guest", "GuestNo = '" & [Reservations[B][COLOR=Red]][/COLOR][/B].[B][COLOR=Red][[/COLOR][/B]GuestNo] & "'")

and let us know how it goes.