For my I.T. college homework I have to use the Help facility in Access to find out how to use some functions. But the Help is pretty useless so I would be grateful if anyone could help me with this. The functions are to be performed on a database with the fields: ID, first name, surname, post held, address 1, address 2, address 3,postcode, telephone no, date joined, date of birth.

1. Use the Weekday function to find out who was born on a Saturday or Sunday.
2. Use Ucase to make a new field where 'address3' is in uppercase.
3. Use Left$ to find all the people with a HD postcode.
4. Use Trim to tidy up the post held field.

thanks.