Grouping an Access report by calculated item

[westicle47]

This is a newbie question.

I have created a report that displays Employee number, Name and age. The age is calculated using the DateDiff expression.

I want to sort the report on this Age field (It's a text box) and isolote staff over 65. I assume I do this by writing an expression in the Sorting and Grouping section. Whats the syntax for refering to the new text box. It's called "Age"?

Thanks

Chris.

 

[RoyVidar]

Two recommandations ...

1 - do the datediff thingie in the recordsource (aka the query) of the report
2 - take your searches and questions relating to Access to the Access fora (there's seven of them, including forum703, which is the reports forum)

- if you haven't had a read at one of the "how to get the most out of the membership" faq's here's one from the Access fora faq181-2886, good luck!

Roy-Vidar

 

[westicle47]

Thanks Roy

The first thing I did was to click on FAQ's but all this showed me was about 5 FAQ's mainly based on Excel and/or VBA. I'm afraid in my techno-numptiness I don't know how to find a directory of all the FAQ's available. Further to my techno-numpty state of ignorance I hadn't thought Access forums would exist anywhere other than under the Microsoft Office heading. You live and learn I guess.

I shall try your suggestion now and direct any further queries to the correct audience.

Thanks again.

Chris.