query help plz

  • Thread starter Thread starter newuser
  • Start date Start date
N

newuser

hey i have been given a set of data which i have set my relationships and
everything is going well,but (now this is when it gets tricky) i have been
given two name fields one for forename and one for lastname,but i havebeen
asked to display the members first intial,but havent been given seperate data
for it (its too go on a labels in reports)how would i go about searching for
jus the first letter of theri first name ? for loadz of entries??? cheers
 
Use the Left function in the query. It would look something like this in the
Field row:

FirstInitial: Left([forename],1)
 
Back
Top