Start\End Date Query

[Rohit Thomas]

Hello All,

I'm have the following query attached to a combo box
called cmbStartDate:

SELECT DISTINCT [qryBank001TellerFifty&Under].FileDate
FROM [qryBank001TellerFifty&Under] WHERE
((([qryBank001TellerFifty&Under].FileDate) Is Not Null))
ORDER BY [qryBank001TellerFifty&Under].FileDate DESC;

I have another combo box called cmbEndDate in which I
would like to use a similar select query but have the
query only show dates that are greater than the date
selected in cmbStartDate.

Any help would be appreciated.

Thanks,
Rohit Thomas

 

[Gerald Stanley]

In the cmbStartDate AfterUpdate eventhandler, place code
similar to
cmbEndDate.RowSource = "SELECT DISTINCT
[qryBank001TellerFifty&Under].FileDate
FROM [qryBank001TellerFifty&Under] WHERE
((([qryBank001TellerFifty&Under].FileDate) Is Not Null))
AND ([qryBank001TellerFifty&Under].FileDate) > #" &
Format(" & cmbStartDate.Value, 'dd/mm/yy') & "#
ORDER BY [qryBank001TellerFifty&Under].FileDate DESC;"

Hope This Helps
Gerald Stanley MCSD

 

[Rohit Thomas]

Thank you very much Gerald. That did the trick.

Rohit

-----Original Message-----
In the cmbStartDate AfterUpdate eventhandler, place code
similar to
cmbEndDate.RowSource = "SELECT DISTINCT
[qryBank001TellerFifty&Under].FileDate
FROM [qryBank001TellerFifty&Under] WHERE
((([qryBank001TellerFifty&Under].FileDate) Is Not Null))
AND ([qryBank001TellerFifty&Under].FileDate) > #" &
Format(" & cmbStartDate.Value, 'dd/mm/yy') & "#
ORDER BY [qryBank001TellerFifty&Under].FileDate DESC;"

Hope This Helps
Gerald Stanley MCSD

-----Original Message-----
Hello All,

I'm have the following query attached to a combo box
called cmbStartDate:

SELECT DISTINCT [qryBank001TellerFifty&Under].FileDate
FROM [qryBank001TellerFifty&Under] WHERE
((([qryBank001TellerFifty&Under].FileDate) Is Not Null))
ORDER BY [qryBank001TellerFifty&Under].FileDate DESC;

I have another combo box called cmbEndDate in which I
would like to use a similar select query but have the
query only show dates that are greater than the date
selected in cmbStartDate.

Any help would be appreciated.

Thanks,
Rohit Thomas
.

.