Query wizard in Access 2003 vs 2007

[Richard Champlin]

I am trying to learn how to create a simple select query that must display an
average price per customer over a certain value. I have added the fields
that I think need to be in the query. However, the problem is the exercise
is based on Access 2003, while I have Access 2007 installed on my computer.

When it gets to the point where it says do you want to modify the query, I
cannot figure out how to get into design view so that I can add a result
column and specify criteria. The Access 2007 query wizard does not let me
choose the Next button, only Finish. What am I doing wrong?

Richard Champlin

 

[Allen Browne]

After you save the query, right-click it in the Navigation Pane, and choose
Design.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Richard Champlin]

Okay,
I am in design view (I had to resize and play with the windows to realize I
was there). However, there is no Total row. Why is that? Is it because I
chose to summarize rather than show details of records?

 

[Allen Browne]

In query design view, there's a big Sigma icon button (text reads 'Totals')
on the Design tab of the ribbon, in the Show/Hide chunk (right-hand side) in
Access 2007.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

message