ACCESS FEED: RE: [MS_AccessPros] Ageing Query

Jumat, 08 Maret 2013

RE: [MS_AccessPros] Ageing Query

Shekar-

What is the SQL of your query? Are you using this query in a form or
report?

If you current query contains a reference to Date(), you can replace that
with a parameter. Instead of Date(), enter something like:

[Enter date:]

Because Enter date: isn't likely to be a field in your tables, Access will
prompt the user for the value when the query runs.

If you have a form open where the user can specify or select a date value,
you can create a parameter that looks like:

[Forms]![MyForm]![txtDateChosen]

.. where "MyForm" is the name of your form and "txtDateChosen" is the name
of the control containing the date value.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of tchshekar
Sent: Thursday, March 07, 2013 6:26 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Ageing Query

Hi

I am looking for ageing query say 0-30, 31-60, and so on, but the problem is
The Now()date / Today() should be replaced with a date which should be at
our discretion, and as required.

i.e we should be able to generate report on any Past date.

Thanks

Shekar

[Non-text portions of this message have been removed]