By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,078 Members | 1,846 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,078 IT Pros & Developers. It's quick & easy.

MS. Access, Time and billing template.

P: n/a
Hello all,
Newbie to MS Access.

I started using the Time and Billing template a couple of days ago. Now for
the fun part, changing what I have to what I can use.
Ok, On the screen I have two initial windows. The Database(minimized).
and the main switchboard. If I'm in the report view window. I click on
"Client billings by project" I'm asked to input dates for this report.
I would like to create an input box that could override this date box, and
ask to input "Projects" for the report. What I'm getting now is a listing
of projects based on a date range. I want a single project listing.
I can get into design view and play around a bit. But haven't done any
serious editing yet.

TIA

Frantic3d
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ideally, you should put a ListBox of Projects on the report's criteria
form. Then you can select the projects you want to report on from the
ListBox and have the report filter the RecordSource for just those
selected projects and the date range you entered on the criteria form.

There are many discussions of this method on this newsgroup's archive
(Google - Groups). Search for criteria form's, reporting, report
filtering, etc.

If you can't find anything I'm sure someone else can steer you in the
right direction. Or, get the K.Getz, et.al. book _Access # Developer's
Handbook_.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

Frantic3d wrote:
Hello all,
Newbie to MS Access.

I started using the Time and Billing template a couple of days ago. Now for
the fun part, changing what I have to what I can use.
Ok, On the screen I have two initial windows. The Database(minimized).
and the main switchboard. If I'm in the report view window. I click on
"Client billings by project" I'm asked to input dates for this report.
I would like to create an input box that could override this date box, and
ask to input "Projects" for the report. What I'm getting now is a listing
of projects based on a date range. I want a single project listing.
I can get into design view and play around a bit. But haven't done any
serious editing yet.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.