Microsoft Access - anyone know how to..

[hotpotmama]

turn address details going across the spreadsheet ie. name in A1, address in B1, B2, B3 etc into labels so the name is at the top (A1) and the address is on lines (B1, C1, D1, etc) underneath?

Am trying to do it in excel using lookups but there must be a way in access just don't know what it is.

Thanks.

Look under reports - there is a wizard for making labels.

thanks alienears will do.