courses in microsoft access - altered view query design

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

courses in microsoft access - Altered view in Query Design View

resolvedResolved · Low Priority · Version Standard

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

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


 

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


Server loaded in 0.08 secs.