Simplistic pointer required

  • Thread starter Thread starter Stan Smith
  • Start date Start date
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
 
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
 
Back
Top