Need help on DCount

[nilses]

Hello, I have a basic question but I do not see how to make.

In a code VBA, I would like to calculate the number of day between two dates in a variable like this

hello = DCount(?)

I have a query with a field dateStart and a DateEnd. I would like to count the number of day between these two dates with DCount but I do not see how to make!!. Normally, It's like that

DCount(Name of the field, name of the query or the table, the SQL )

but I cannot integrate two fields. I looked in the forum but I did not find my answer.

Could you help me.

Thank you Nilses

 

[WayneRyan]

Nilses,

Look in the Help files for the DateDiff function.

Wayne