Hi all,
I recently started a business selling 1st edition books and decided to use Access for my records. I have a limited past experience with Access and am OK with the basics of creating tables, forms, reports and basic queries.
I am trying to create a query to extract records by AUTHOR SURNAME. Everything I've tried so far requires me to type the FULL surname and forename to extract the info. The "author" column contains the full name, eg "DEIGHTON Len" (no comma).
Can anyone help, please?