SQL code for select query

[mcgooie]

Im looking to have a query that selects the "NAME" from a table "tblPeople" where the NAME field begins with "A". Ive tried using WHERE tblPeople.NAME Like "A" with no luck.

Can anyone help me out, im sure im missing something really simple.

 

[mcgooie]

just realised my mistake when i submitted question. i should have used Like "A*"