No SQL Aggregate Functions in Expression Builder

[JiLilliput]

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 lesson, tell me to select Built-In Functions in the Expression Elements box, then SQL Aggregate in the Expression Categories box, then Count in the Expression Values box.

My problem? SQL Aggregate is not listed in the Expression Categories box. Anyone know how I get those? Do I have to install something?

Any help would be appreciated.

Jill

 

[VilaRestal]

In the Expression Builder: Left hand box double-click Functions and then click Built in Functions
In the middle box there should now be many types. Near the bottom (scroll down) should be SQL Aggregate.
Is that what you've done? Do you not have that?

 

[JiLilliput]

Exactly what I did, and SQL aggregate is not listed in the middle box.

 

[VilaRestal]

Do you get the <All> option at the top of the Expression Categories box?

If so do you get Avg, Count, Max, Min in the Expression Values box?

Sorry, no ideas to fix it either way.

I'd also be curious whether you get SQL Aggregate in an Expression Builder launched from the Query Designer rather than a table's calculated field.

 

[JiLilliput]

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

 

[JiLilliput]

tried to attach a screen shot. Don't think it worked.

Jill

 

[JiLilliput]

I'd also be curious whether you get SQL Aggregate in an Expression Builder launched from the Query Designer rather than a table's calculated field.

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?

 

[rGen]

JiLilliput --


I think I am taking the same class (Universal Class?). I was confused by the very same thing, until I finally noticed in the screenshot that on the very top line of the screenshot it said "Enter an expression to define the calculated query field".

In other words, he switched contexts on us. The screenshot in question is launched from within query design, not table design as the context of the discussion suggests.

SQL aggregate and Domain aggregate are options in the expression builder when launched from within the query design window.

I realize this is an old post, and you've probably figured the above out by now, but I'm posting this for any fellow travelers who might happen on this page.

Maybe save somebody some time.