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?
You setting up your own dating agency again ziggy ?
No.
*whistles nonchalantly*
Not sure. In excel it can be created very easily
Is Maggie not a whizz at MS access (according to herself). Or is it Treasurer?,
Quote from: Bensars on February 24, 2010, 10:48:48 PM
Not sure. In excel it can be created very easily
Has to be on Access unfortunately.
Quote from: Denn Forever on February 24, 2010, 10:50:08 PM
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.
Feck, I've no idea.
Ask me another about SAP Crystal, Business Objects or Oracle Discoverer?
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 ]