MS Access Questions

[ziggysego]

We have Excel questions, we may as well have Access questions.

I am creating a simple database for someone. They want to be able to print queries, but pick the variables themselves.

For example. How many people from Tyrone in a database are working in the manufacturing sector?

In the database, there will be many people from across the north, working in different sectors. How do I create a report that I can select the above?

[Bensars]

You setting up your own dating agency again ziggy ?

[ziggysego]

No.

*whistles nonchalantly*

[Bensars]

Not sure. In excel it can be created very easily

[Denn Forever]

Is Maggie not a whizz at MS access (according to herself).  Or is it Treasurer?,

[ziggysego]

Not sure. In excel it can be created very easily

Has to be on Access unfortunately.

Is Maggie not a whizz at MS access (according to herself).  Or is it Treasurer?,

Not sure about maggie, but I know Treasurer is good with Access.

[Orior]

Feck, I've no idea.

Ask me another about SAP Crystal, Business Objects or Oracle Discoverer?

[Mac hinery]

Query design view for a select Query, in the criteria section for your example use square brackets with question or prompt in each field you want to pass a variable to e.g.

[ What county ]

[ What sector ]