M mugman17 Registered User. Local time Today, 21:59 Joined Nov 17, 2000 Messages 110 May 5, 2003 #1 This is probably an easy one. I just need to have a query sorted by the first letter of the last name. So if a text box has an "A" in it, the query would just show every last name that starts with "A".
This is probably an easy one. I just need to have a query sorted by the first letter of the last name. So if a text box has an "A" in it, the query would just show every last name that starts with "A".
jfgambit Kinetic Card Dealer Local time Today, 21:59 Joined Jul 18, 2002 Messages 798 May 5, 2003 #2 Add the Following to the Query as a new field: LInitial: Left([Lastname],1) Then point that field to the textbox (i.e. in the Criteria of the field add [Forms]![frmNames]![LInitialTextbox]) HTH
Add the Following to the Query as a new field: LInitial: Left([Lastname],1) Then point that field to the textbox (i.e. in the Criteria of the field add [Forms]![frmNames]![LInitialTextbox]) HTH
