M mariaw Registered User. Local time Today, 20:37 Joined Jun 9, 2006 Messages 88 Dec 8, 2006 #1 Here it is: =Count(IIf([Calendar Date]>=[First Day] and <=[Actual Last Day]) ??? Maria
M MStef Registered User. Local time Today, 20:37 Joined Oct 28, 2004 Messages 2,251 Dec 8, 2006 #2 Hello Maria! Everything is wrong. What do you want to Count ????
M mariaw Registered User. Local time Today, 20:37 Joined Jun 9, 2006 Messages 88 Dec 8, 2006 #3 Formula Hi Sorry - I see what you mean; I want to count the number of days if they fall between the [First Day] and the [Actual Last Day]? Maria
Formula Hi Sorry - I see what you mean; I want to count the number of days if they fall between the [First Day] and the [Actual Last Day]? Maria
M MStef Registered User. Local time Today, 20:37 Joined Oct 28, 2004 Messages 2,251 Dec 8, 2006 #4 It is not enough, tell me how your table looks like. Do you want to do COUNT in the query or in the form, and s.o.
It is not enough, tell me how your table looks like. Do you want to do COUNT in the query or in the form, and s.o.
