courses in microsoft access - Altered view in Query Design View

The UK's most regular instructor-led training courses.
Training information: courses in microsoft access · Microsoft.access.courses · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Altered view in Query Design View

Clare has attended:
Access Introduction course

by - delegate Clare [6 posts] (2007 Feb 13 Tue, 11:30) Reply

Hi

When I go into design view of a query in a database that I am using, instead of the fields where I would specify my criteria going down a column, they are going across rows instead, how do you alter the view to make it go down the columns?

Thanks

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 2 Tue	Southwark	3	book now	£210	£215
2003	2008 Sep 9 Tue	Bloomsbury	6	book now	£193	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
Full Schedule: See all 73 Access Intermediate course dates. Bookings currently available until 24th November 2009.

Altered view in Query Design View

by - trainer Carlos gold contributer [394 posts] (2007 Feb 20 Tue, 09:44) Reply

Hi Clare

I'm not sure what you mean as the only views in Query are Design, SQL and pivot.

Could you take a screen shot of your Query in design view to

forum AT microsofttraining.net

so I can see what you mean

Carlos

· Innovation with Microsoft Access
· Why consider Access Visual Basic training?
· Take an Access Course to Learn About Relational Databases
· Access Database Optimization: First Normal Form
· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips