Between Two Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was asked to help out with the following code but am only a novicee
programmer so I have no idea. Can someone tell me why #name? always appears?
Thanks.

=iif([date 07] Between Now() And Now()-365,Sum([07 hours]))
 
What exactly are you trying to do and where? The IIF function usually has
three parts (evaluation, true, false); your expression has only two. What
are you trying to sum? There is a function called DSum in Access that is
used in forms but it requires more than one input.
I was asked to help out with the following code but am only a novicee
programmer so I have no idea. Can someone tell me why #name? always appears?
Thanks.

=iif([date 07] Between Now() And Now()-365,Sum([07 hours]))
Click to expand...
 
Sorry, the person who is doing this isn't here at the moment and I was only
asked about the #name? part. I already told them there are three parts to an
IIF.

She is trying to Sum the number of hours spent on a project over the last
year. She is doing this on her form. I hope that helps otherwise I will
have to wait for her to return.

kingston via AccessMonster.com said:
What exactly are you trying to do and where? The IIF function usually has
three parts (evaluation, true, false); your expression has only two. What
are you trying to sum? There is a function called DSum in Access that is
used in forms but it requires more than one input.
I was asked to help out with the following code but am only a novicee
programmer so I have no idea. Can someone tell me why #name? always appears?
Thanks.

=iif([date 07] Between Now() And Now()-365,Sum([07 hours]))
Click to expand...
Click to expand...
 
#name just means that Access doesn't recognize, in this case, the function
name you're trying to call (Sum). It sounds like a Totals Query would be
more appropriate

Group by Project, Sum on [07 Hours], Where [date 07] Between Now() And Now()-
365
Sorry, the person who is doing this isn't here at the moment and I was only
asked about the #name? part. I already told them there are three parts to an
IIF.

She is trying to Sum the number of hours spent on a project over the last
year. She is doing this on her form. I hope that helps otherwise I will
have to wait for her to return.
What exactly are you trying to do and where? The IIF function usually has
three parts (evaluation, true, false); your expression has only two. What
Click to expand...
[quoted text clipped - 6 lines]
=iif([date 07] Between Now() And Now()-365,Sum([07 hours]))
Click to expand...
Click to expand...
Click to expand...
 
Back
Top