can someone help me please - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

can someone help me please

Author

Topic

patelhasu
Starting Member

13 Posts

Posted - 2002-04-19 : 10:24:22

i have this sql statement and i wrote a fucntion that gets the date but now i want to use that function to get a between records for those dates

here is the sql statement i'm using
********************************************************************
Me.RecordSource = "Select DISTINCT DEMOGRAPHIC_Full.EthnicCode,
DEMOGRAPHIC_Full.Grade, " & _
"EWTransfers.EWWCode FROM EWTransfers INNER JOIN DEMOGRAPHIC_Full ON EWTransfers.EWID = DEMOGRAPHIC_Full.ID " & _
"WHERE 'Between' &((EWTransfers.EWWDate)>='" & Get525Date(1) & "') And (EWTransfers.EWWDate)<'" & Get525Date(2) & "') "
********************************************************************
It does not return any records if i use the Between the way i have it now. Am i missing something

Thanks

nricardo
Starting Member

17 Posts

Posted - 2002-04-23 : 11:14:34

quote:

i have this sql statement and i wrote a fucntion that gets the date but now i want to use that function to get a between records for those dates

here is the sql statement i'm using
********************************************************************
Me.RecordSource = "Select DISTINCT DEMOGRAPHIC_Full.EthnicCode,
DEMOGRAPHIC_Full.Grade, " & _
"EWTransfers.EWWCode FROM EWTransfers INNER JOIN DEMOGRAPHIC_Full ON EWTransfers.EWID = DEMOGRAPHIC_Full.ID " & _
"WHERE 'Between' &((EWTransfers.EWWDate)>='" & Get525Date(1) & "') And (EWTransfers.EWWDate)<'" & Get525Date(2) & "') "
********************************************************************
It does not return any records if i use the Between the way i have it now. Am i missing something

Thanks

The correct use of between is WHERE column_name BETWEEN low_value AND high_value.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources