Using Parameters in Commands

[gavinjb]

I am connecting to an Access/Jet 4 Database and I am trying to create a Command that uses one Paramater "InvoiceDT", I need to be able to tell crystal to only return rows with an Invoice Date >= "InvoiceDT" Parameter, but when I try this with "[]" or "{}" brackets I get ADO error messages when trying to clicking on OK, any help would be appreciated

Thanks,

Gavin

 

[synapsevampire]

Where are you placing this, and what exactly are you placing in there, and what is the error?

To limit rows in CR, select Report->Edit Selection Formula->Record and place something like:

{table.field} >= {?InvoiceDt}

Now create a parameter field (Insert->Fioeld Object->Rioght click Parameters and select New)

Set the parameter to type date.

-k