Just saw that you asked this question. YES! I do get SQL Aggregate in an Expression Builder when launched form the Query Designer. Am I supposed to have it in both places?
I do have the <All> option in the Expression Categories box, but Avg, Count, Max, Min (and any of the others that are shown in the picture) do not appear in the Expression Values box.
Thank you for trying to help me!
Jill
I am taking a self-paced MS Access 2010 class using MS Access 2010. Am about half way through the course, and am working on the lesson entitled "Creating Calculated Expressions." One of the assignments is to create an calculated field in a table.
The instructions, and the picture in the...
Just starting to learn Access, and I am starting with Access 2010. I am taking a self paced course to start, then plan on taking a class with an instructor so I can ask questions.
Will have questions! And hope you can help me!
Jill