Calculation help 1

[DrillMonkey]

Hi forum,

I have a form called Brookhurst on this form I have (2) controls; the first control is named Packages, and the other is named Total. I want the Packages control to be summed and displayed into the Total control based on this criteria >=date(). After midnight this returns to null. I have a query already set to this >=date() but I think I need some (SQL) code to accomplish this.

Thanks,
Richard

 

[SkipVought]

Richard,

WHAT are you talking about???

YOU know what's in your head.

Unfortunately, my crystal ball is foggy today.

"... I have a query already set to this >=date() ..."

Well, it might be somewhat helpful if we could have a peek.

"I want the Packages control to be summed "

What kind of a control? What are the values associated with the control?

"...displayed into the Total control based on this criteria >=date()."

what is criteria? Usually a CRITERIA is some OPERATOR, so in general terms...
[tt]
value1 criteria value2
[/tt]
like

xtxMyDate.Value >= Date()

But again, that exression means absolutely nothing outside the context of your query, which you seem to be hiding under a bushel

Skip,

_[red][/red]

 

[DrillMonkey]

Lets forget the select query I mentioned I apolgize for that. The user needs to see the total packages before he prints the report. And I am able to do that, heres my problem what happens when the user opens the form tomorrow?
It will continue to Calculate yesterdays totals which will be incorrect. I need the control to be "null" at the start of a new day.

 

[SkipVought]

Why won't that work?
[tt]
Yourdate = Date()
[/tt]




Skip,

_[red][/red]

 

[DrillMonkey]

It might, I just don't know how... I've tried to get my select query to that but, I'm an Access rookie 4 months of experience.

 

[TheAceMan1]

easy Skip! . . . EASY! . . .

I'm sure you've been here before! . . .

[blue]Remember when you were learning?[/blue] . . .

See Ya! . . . . . .

 

[DrillMonkey]

Hi AceMan

 

[TheAceMan1]

Howdy DrillMonkey . . .

Taking over this thread from another respected tipster is not my intent . . . I'm sure [blue]Skip[/blue] is already in tune with the demeanor of my previous post (I'll monitor just incase).

Make way for his [blue]prowess![/blue] . . .

[blue]Skip![/blue] . . . your pickup! . . .

See Ya! . . . . . .

 

[DrillMonkey]

Yeah no problem,

 

[DrillMonkey]

I can get my form to Calculate, I just can't figure out how to make stop Calculating ...as in start over? thats why I wanted to use this >=date() in my date field of my query...am I wrong or off base? I use this in my Totals control
=Sum([packages]) on my form

 

[PHV]

Have a look at the DSum function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[PHV]

Another way, provided the RecordSource contains the date field:
=Sum(IIf([date field]>=Date(),[packages],0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[DrillMonkey]

Thanks to all who replied to this thread. I was able to acomplish what I need with

=DSum("packages","BrookhurstQuery")

 

[DrillMonkey]

=DSum("packages","BrookhurstQuery")[code]