VB6 & Crystal Report v10 Coding

[mickofgoju]

I am using VB 6 and Crystal report v10.

I have a field that is the type of training session a student does, i.e. "Beach Training".

I want to retrieve all the sessions from a given date i.e. "Last Grading date" The code, in VB6, is not working any help much appreciated.

Below is the code I am using:

myReport.RecordSelectionFormula = "{qry_ATTENDANCE.SESSION}= '" & frm_CryReports.dbc_FillMembers.Text & "' and " & " > {qry_Attendance.Last Grading Date} & "

[rpicilli]

HI,

I'm not a speciallist in Crystal Report but in your query, looks a like that is missing a simple quote on last parameters.

myReport.RecordSelectionFormula = "{qry_ATTENDANCE.SESSION}= '" & frm_CryReports.dbc_FillMembers.Text & "' and "' & " > {qry_Attendance.Last Grading Date} & '"
 

Try this and let me know if work out.

RPicilli

[mickofgoju]

HI,

I'm not a speciallist in Crystal Report but in your query, looks a like that is missing a simple quote on last parameters.

myReport.RecordSelectionFormula = "{qry_ATTENDANCE.SESSION}= '" & frm_CryReports.dbc_FillMembers.Text & "' and "' & " > {qry_Attendance.Last Grading Date} & '"
 

Try this and let me know if work out.

RPicilli

Hi RPicilli

Thanks for your suggested code. Unfortunately not working but it does not give me the same error so its on the right track.
I may need to look at formatting the date field.
Again thanks for your help

Mick