expression builder not showing query fields

[SmallTime]

Using Access 2010

Does anyone know why fields aren't appearing in the expression builder

As you can see from the attached image there should be 3 fields in expression categories column.

This is really stumping me.

Regards
SmallTime

 

[boblarson]

What are you trying to calculate?

 

[SmallTime]

Hi Bob

I got the calculation done OK, just went back to good old VBA and managed it in no time.

I've just started using 2010 and it seems odd that the field names aren't appearing in the expression builder. Is it a feature!

Regards
SmallTime

 

[boblarson]

It depends on where you are when trying to use it. You can build a calculated field in a table in Access 2010 (although it isn't probably the best to use except if you have a web app and can't do aggregates because of that). But now that I go back and look at the screenshot again, you would have had to expand the ProWideFoods.accdb area which would have given you tables/queries, etc. The TEST thing that was at the top is the query you were in.

So anyway, if you had typed in the expression you wanted in the query itself, intellisense (new in queries in 2010) would have assisted. It is pretty cool to have that.

 

[SmallTime]

Yeup, intellisense is a really good and helpful addition.

I did also open the query in ProwideFoods but still no fields. I suspected something was amiss which compacting wasn't sorting out so imported everything in a new database and hey presto all is now well.

I started this project 2 days ago and haven't done anything out of the ordinary (yet) so am quite surprised that corruption had already started creeping in. Hope this isn't a sign of things to come.

I love the table-level calculated fields. Don't quite know yet what I might use them for as I haven't ever developed web based thingy's (my clients use Citrix) but nice to have the option.

Take Care
SmallTime