Simplistic pointer required

S

Stan Smith

Hi - can any kind soul point me in the direction of a good source of clear
guidance on how to create output from Access 2002 database.
From the database I have to query 2 columns - Call_date and Bay (where Bay
can be either A,B,C,D). What I need to do is to be able to input a range of
dates and have the query display the number of calls to each of the bays
during that period.
Whilst I realise I will have to initially create the query in Query builder
I dont want the operators (who are very PC novices) to have to use the query
builder!! (far too technical).
But despite having read 2 or 3 books I can find no examples of how to build
a front end user-friendly form which will guide the user as to what is
required for them to enter.
So ay advice would be most helpful.

Many thanks


Stan
 
J

JulieD

Hi Stan

the basic steps to achieving this are:
1. create the query that the report is to be based on
2. use the report wizard to build a report based on the query
3. create an unbound form in design view ... placing on it two text boxes
(name them startdate & enddate) close & save form
4. return to the query, click in the criteria line of the call_date field
5. click on the expression builder icon on the toolbar
6. type in the box at the top BETWEEN then go to forms / all forms / find
the form created in step 3, in the centre
section double click on the startdate control then type AND and then double
click on the enddate control
7. close & save query
8. return to the form & put a command button on it to open the report in
print preview mode - close & save form
9. open form, enter your dates and click print button

let us know how you go - ps i have an example database showing the above, so
if you'ld like to email me direct i'll send it to you.

Regards
JulieD
 
Top