Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » courses in microsoft access - Altered view in Query Design View

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

courses in microsoft access - Altered view in Query Design View

Resolved · Low Priority · Version Standard

Reply Tue 13 Feb 2007, 11:30Delegate Clare said...

Clare has attended:
Access Introduction course

Altered view in Query Design View

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

For upcoming training course dates see: Pricing & availability

Reply Tue 20 Feb 2007, 09:44Trainer Carlos said...

Altered view in Query Design View

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

Access articles

· Record, Find And View Data Easily Thanks To Microsoft Access
· Understanding The Components Of Access
· An Essential Guide To Using The Northwind Database In Access 2010
· Getting To The Nitty-gritty Via Microsoft Access
· Microsoft Access 2007: New Features

Access tip:

Random sampling

Data is th key to a good database, therefore checking is essential.

A good way of checking data is by random sampling. You can do this in a query, by typing the follow:
1) In the Field box create a RandonID field eg. Randon Id: Rnd(fieldname])

2) sort the field
3)Right click and chage the properties for To value to be the number of randon records you want to see.

4) Change the set to Show row for Randon ID to be False, add all the other fields you want to see and the run the query.

View all Access hints and tips