Two date feilds in query - is this possible in my report?

[Johnrg]

I have a report thats data source is a query.

This query has two date feilds (DateRequired and DespatchDate) DateRequired always contains data but DespatchDate can be blank or filled out depending on user input.

Currently the report shows the DateRequired feild but a user has asked me if it is possible to add code or perhaps format the report so that it shows the DateRequired data only if the DespatchDate feild is empty but reverts to showing the DespatchDate if both feilds contain data.

This sounds possible but is beyond my limited capabilities.

Could someone help me out with this.

I am a novice user - pretty good with formatting but a laearner with code.

Thanks form New Zealand

JohnG

 

[pbaldy]

You can use the Nz() function.

 

[Johnrg]

Hi Paul,
Could you expand on that a little?
As I explained I am a novice and using the nz() function means nothing to me.
Thanks
JohnG

 

[pbaldy]

You should find plenty of info in help.

Nz(FirstField, OtherField)