Sum If

[Guest]

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

 

[Guest]

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

Thank you. I could not get it to work without the Abs reference - but I
don't really know why. Your solution provides an incorrect answer.

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

The asterisk in the formula to me means you are multiplying.

What is BudgetHrs multiplied with?
--
KARL DEWEY
Build a little - Test a little

Thank you. I could not get it to work without the Abs reference - but I
don't really know why. Your solution provides an incorrect answer.

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

:

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

Karl,

Search for my other message SumIf Help, posted 8/6 (it also explains why it
got posted twice - I apologize, but I had a difficult time finding this one
again.) Duane gives an explanation.

Thanks for your help.

The asterisk in the formula to me means you are multiplying.

What is BudgetHrs multiplied with?
--
KARL DEWEY
Build a little - Test a little

Thank you. I could not get it to work without the Abs reference - but I
don't really know why. Your solution provides an incorrect answer.

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little


:

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

:

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

That did not answer the question I posed.
--
KARL DEWEY
Build a little - Test a little

Karl,

Search for my other message SumIf Help, posted 8/6 (it also explains why it
got posted twice - I apologize, but I had a difficult time finding this one
again.) Duane gives an explanation.

Thanks for your help.

The asterisk in the formula to me means you are multiplying.

What is BudgetHrs multiplied with?
--
KARL DEWEY
Build a little - Test a little

Thank you. I could not get it to work without the Abs reference - but I
don't really know why. Your solution provides an incorrect answer.

:

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little


:

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

:

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA

 

[Guest]

I believe it's being multipled by the 1 returned from the Abs result.

That did not answer the question I posed.
--
KARL DEWEY
Build a little - Test a little

Karl,

Search for my other message SumIf Help, posted 8/6 (it also explains why it
got posted twice - I apologize, but I had a difficult time finding this one
again.) Duane gives an explanation.

Thanks for your help.

The asterisk in the formula to me means you are multiplying.

What is BudgetHrs multiplied with?
--
KARL DEWEY
Build a little - Test a little


:

Thank you. I could not get it to work without the Abs reference - but I
don't really know why. Your solution provides an incorrect answer.

:

Your last post makes no sense to me but the earlier should be like ---
IIf ([ProjectFYE] between #1/1/2006# and #12/31/2006#, Sum([BudgetHrs]),
Null)
If not Null then for the false results then whatever you need such as 0 (
zero ).

--
KARL DEWEY
Build a little - Test a little


:

Well, I've been searching and working on this for at least 3 hours, but I
finally got it. Here it is if it can help anyone else:

=Abs(Sum(([ProjectFYE] Between #01/01/2006# And #12/31/2006#)*[BudgetHrs]))

:

Hi, I posted this, but I'm not really sure where it ended up. It should be
here in General, but it seems to be under just "access". Anyway, don't take
offense, here it is again.

Hi, I want to do something like this:

If [ProjectFYE] between #1/1/2006# and #12/31/2006# Sum [BudgetHrs].

I want to do this in a report group footer.

TIA