Help in iif statement in query

[deanvilar]

Help guys,

how should I put execute this iif statement in query

iif assetMovementTable.toDate = assetMovementTable.fromDate, print in report assetMovementTable.fromEndDate, get value of label End Date

after executing the iif, where should I place it in my below query?

SELECT * FROM assetMovementTable
WHERE (((assetMovementTable.toJobCode) Like Forms!ASSET_MOVEMENT_PRINT_MODULE!txtJobCode & "*" And (assetMovementTable.toDate) Between Forms!ASSET_MOVEMENT_PRINT_MODULE!txtFromDate And Forms!ASSET_MOVEMENT_PRINT_MODULE!txtToDate))
ORDER BY assetMovementTable.assetNo, assetMovementTable.moveCode;

[Rabbit]

iif(toDate = fromDate, fromEndDate, label End Date

I don't know what you mean by label End Date so you'll just need to fill in that blank.

[deanvilar]

sir rabbit, label end date is the label in the report..

[Rabbit]

Then you'll just need to place in that reference. I don't know why you would be using a label though. And from a report for that matter. That would require that the form be open before the query is run. It doesn't make any sense.

[deanvilar]

I have a start and end date labels in the report linked in textboxes entered by user, so if assetMovementTa ble.toDate = assetMovementTa ble.fromDate then print in report assetMovementTa ble.fromEndDate else get the value of label End Date

[Rabbit]

Well then put in a reference to the text box that the user uses. Not a reference to the report label.

[deanvilar]

oh yes u r right! thanks for your help ..

[Rabbit]

Glad to help, good luck with the rest of your project.

[deanvilar]

thank you very much again sir Rabbit.