Book

Suggestions


Enter your email address:

Delivered by FeedBurner


Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?
Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal









Subscribe here
Add to My Yahoo!
This page is powered by Blogger. Isn't yours?

Host your Web site with PureHost!


eXTReMe Tracker
  Web http://www.klippert.com


  Friday, August 28, 2009 – Permalink –

Parameter v. Form

You have a choice



There are a couple of ways to limit the data that is displayed in a Query or in a report.
One is a Parameter Query
  1. Create a query to use as the RecordSource of your report.
  2. In query design view, in the Criteria row under your date field, enter:

    Between [StartDate] And [EndDate]
The other is to create a specific form. The unbound form has the following advantages:
  • Flexible: user does not have to limit report to from and to dates.
  • Better interface: allows defaults and other mechanisms for choosing dates.
  • Validation: can verify the date entries.
Allen Browne has supplied a clear explanation along with some typical code.

Also see FontStuff.com:
Using Parameter Queries




See all Topics

Labels: , , ,


<Doug Klippert@ 3:02 AM

Comments: Post a Comment