Macros

[Former Member]

Hi all,

Iam using a sql statement to retrieve records for a particular period in macros.

My sql statement is as follows:

sSql = sSql & " WHERE (FKDAT Like '" & Sheet1.Cells(3, 2) & "%') " & vbCrLf 'Invoice Date

The from-date is in cell(3, 2) and the to-date In (3, 3). I able to use only one date.

Please help to me to get the correct statement,

Raj.

Message was edited by:

Rajesh Kumar

[former_member185954]

Hi Rajesh,

The macro should be :

where FKDAT >= Sheet1.Cells(3,2) AND FKDAT <=Sheet1.Cells(3,3)

i am ignorning the formatting assuming that you know it

Regards,

siddhesh