courses in microsoft access - Altered view in Query Design View

Resolved · Low Priority · Version Standard

Tue 13 Feb 2007, 11:30 Delegate 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

Tue 20 Feb 2007, 09:44 Trainer 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 stl-training.co.uk

so I can see what you mean

Carlos

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

View all Access hints and tips