queries

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

Queries

resolvedResolved · Low Priority · Version Standard

Otis has attended:
Access Intermediate course
Access Advanced course

Queries

how to crosstab

RE: queries

Hi Otis, Thank you for the post, welcome to the forum, in answer to your question, creating a crosstab query which is a summarisation of your data, the easiest and most straightforward way to do this is to follow the Crosstab query wizard which you can invoke by going to the Queries objects click on New and select Crosstab query wizard, follow the steps to create your query. I look forward to seeing you on the forum in future, best regards Pete.


 

Access tip:

Duplicating an Entry

To duplicate the entry press CTRL+' (apostrophe)this will copy the contents of the previous entry in the same field.
(Table view, line above) note this also works in Excel.

View all Access hints and tips


Server loaded in 0.08 secs.