I would write the select statement, but I never use the grid.
if you do use the grid, realize that dynamically created fields (which are ones you create with functions, expressions, etc...) use this syntax in the "field" name in design view:
Code:
TemporaryFieldName: CodeHere
So in case your whistler 2000 didn't follow that...as an example, if I use a DCOUNT() function like I've already done in this thread and wanted it as an extra field, I say this in a column of the query grid to make that new field:
Code:
CountOfOccurances: dcount("fieldname", "table", "criteria")
for simple criteria, you simply type the code I've already posted into the CRITERIA line of the field column in the query grid. it is identical to writing the statement out by hand.
the different views of the query object are located under the VIEW menu (pre 2007 versions of access) and are on the DESIGN tab in 2007 versions, all the way to the left under VIEW. SQL VIEW is where the statements are kept.