Parameters Question

[Guest]

I am creating a query for a commissions database that will give me a list of
payments that is due within a specific time period. I have a
FirstBillableMonth field that gives the date of the first invoice and a
DueDate field, which is a calculated field, that calculates when the payment
is due (based on the first invoice date). I want this query to show me only
those items that are due within 2 dates that needs to be typed in.

In the criteria section of the DueDate field, I typed in: Between [Type
Begin Date:] And [Type End Date:] . The parameters box popped up and I
entered the 2 dates, however, I did not get the correct query result.

I also set up the parameters in the Query Parameters dialog box. But this
time, it asked me the same questions twice. My results were still incorrect,
it gave me the correct months, but for all of the years currently in the
table.

Please tell me what I'm doing wrong.

 

[steve]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
http://www.ammara.com/access_image_faq/access_loading_image_dialog.html


HTH

Steve

 

[Smartin]

sorry

you cant do this with microsoft access 2003.

you must upgrade to microsoft access 2004:
<gratuitous link obliterated>

Why do you reference one HJR who hasn't posted to CDOS in over three
years, much less on the topic of your warez (according to Google)? Do
you have a permalink to support this "accolade"?

[OB MPAQ]

How many DBAs does it take to screw [in] a light bulb?