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

reports

ResolvedVersion Standard

Emma has attended:
Access Introduction course

reports

how do your filter search in reports

RE: reports

Hi Emma, Thank you for your post, In answer to your question if you create your report following the steps in the Report Wizard you will be given the options to sort, group, summarise and filter your records before they are sent to the final report. Another way is to use a query to supply information to the report and filter the data in the query. I hope that helps best regards Pete.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.