FetchData problem

06-03-2009, 1:49 AM
Hi,
can anyone fix Fetchdata problem?

Please See Attch.

Re: FetchData problem

06-03-2009, 1:15 PM
Hello,

Please find the attached sample which gives proper display at my testing.

Regards,
Prantik

Re: FetchData problem

06-04-2009, 2:42 AM
Thank you...

(cnt = cnt + 1)

But I want the value Taken from report field, can you help please?
---------------------------------------------
Like :
SQL = "SELECT Count(CarID)From TblTrans" & " Where CarID = " & Val(Me.CarID.DataValue) & "And Check = " & True

Not Like:
SQL = "SELECT Count(CarID)From TblTrans" & " Where CarID = " & cnt & "And Check = " & True
---------------------------------------------
Best regards,

Re: FetchData problem

06-04-2009, 1:50 PM
Hello,

You could change the SQL statement to the following to get the desired output
SQL = "SELECT Count (CarID) From TblTrans" &” Where CarID = " & Me. Fields ("CarID").Value & "And Check = “& True
Please take a look at the attached sample.

Regards,
Prantik

Re: FetchData problem

06-06-2009, 3:48 AM
Thank you,
That is exactly what I want