Using start and end date to populate subform

  • Thread starter Thread starter Mike Davis
  • Start date Start date
M

Mike Davis

What I would like to do is have a form where you enter a start date and end
date (about a 2 week period), then have a subform populated with columns
with the date at the top of each column, which can then be printed.
(Ideally, have the weekends a different color).

Can someone point me in the right direction?
 
Mike,

If you're talking printing, you probably need a report, not a form.
And if you want a column for each date, it sounds like crosstab.

Therefore, I reckon the basic concept would be:
- unbound textboxes on a form for the entry of the date criteria
- a crosstab query, using the dates in these textboxes as selection
criteria
- a report based on the crosstab query

- Steve Schapel, Microsoft Access MVP
 
In your query grid you could have something like this: You also could use a
form to enter the dates and then run the query.
Base the report on your query and the form with the matching criteria in
your query.Put a command button on the form that opens the report and closes
the form. i.e. minimize the form and or close the form when the report
closes.
Hope thi shelps.
Between [Forms]![name of first field]![BeginDate] And [Forms]![name of
second field]![EndDate]
 
Back
Top