Matching Data Help!!!!

[viralbhatt]

Hello,

I am using this query to get matching data:

SELECT NewMyEstartChild.yordob, NewMyEstartChild.firstname, NewMyEstartChild.surname, NewMyEstartChild.postcode
FROM NewMyEstartChild INNER JOIN For2003 ON (NewMyEstartChild.postcode = For2003.POSTCODE) AND (NewMyEstartChild.yordob = For2003.MyDOB);

but It's giving me more data so to minimise data I was thinking to add another filed. which is Firstname field. but some children's name are spell incorrectly.

How can I match data with first letter only ? I have tries following query but it doesn't work. Please help!!!!!!!!

SELECT NewMyEstartChild.yordob, NewMyEstartChild.firstname, NewMyEstartChild.surname, NewMyEstartChild.postcode
FROM NewMyEstartChild INNER JOIN For2003 ON (NewMyEstartChild.postcode = For2003.POSTCODE) AND (NewMyEstartChild.yordob = For2003.MyDOB) AND (NewMyEstartChild.Firstname = For2003.Firstname);


In last part of this query (NewMyEstartChild.Firstname = For2003.Firstname); How can I get the name of children whose firstname's letter is similar.

Thank you
Viral

 

[KenHigg]

I haven't tested this, but it should be something simple like:

(NewMyEstartChild.Firstname = left(For2003.Firstname,1)


???

 

[viralbhatt]

No data

Sorry it doesn't work

When I add left function part it doesn't show any data.

Final query is this:

SELECT NewMyEstartChild.yordob, NewMyEstartChild.firstname, NewMyEstartChild.surname, NewMyEstartChild.postcode
FROM NewMyEstartChild INNER JOIN For2003 ON (NewMyEstartChild.Firstname = left(For2003.ForeName,1)) AND (NewMyEstartChild.yordob = For2003.MyDOB) AND (NewMyEstartChild.postcode = For2003.POSTCODE);

but not working at the moment

Viral

 

[KenHigg]

(NewMyEstartChild.Firstname like left([For2003]![ForeName],1) & "*")


???