Sum of Quantity Late

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

Guest

I would like to create a box on an intro form that show the results of a sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6) to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it can't have
a received date if the part has not been received)

Any help would be appreciated
 
I would like to create a box on an intro form that show the results of a sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6) to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it can't have
a received date if the part has not been received)

Any help would be appreciated
Click to expand...

I'm not actually certain what you mean by "based on FT200, PF6" - but
guessing that these are fields which identify the records to be
summed, and that they are Number fields displayed on the form in
textboxes named txtFT200 and txtPF6, try setting a textbox's control
source to

=DSum("[QUantity]", "[your-table-name]", "[FT200] = " & [txtFT200] & "
AND [PF6] = " & [txtPF6] & " AND [Actual Received Date On Dock] IS
NULL AND [MRP Need Date] < #" & Date() & "#")


John W. Vinson[MVP]
 
John, there are three fields, 1. Quantity; 2. FT200, PF6, MRP Need Date; 3.
ACTUAL RECEIVED DATE ON DOCK

Fields 2 and 3 are "date" fields.


John Vinson said:
I would like to create a box on an intro form that show the results of a sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6) to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it can't have
a received date if the part has not been received)

Any help would be appreciated
Click to expand...

I'm not actually certain what you mean by "based on FT200, PF6" - but
guessing that these are fields which identify the records to be
summed, and that they are Number fields displayed on the form in
textboxes named txtFT200 and txtPF6, try setting a textbox's control
source to

=DSum("[QUantity]", "[your-table-name]", "[FT200] = " & [txtFT200] & "
AND [PF6] = " & [txtPF6] & " AND [Actual Received Date On Dock] IS
NULL AND [MRP Need Date] < #" & Date() & "#")


John W. Vinson[MVP]
Click to expand...
 
So, modify John's suggesion to suit, ie

=DSum("[QUantity]", "[your-table-name]", "[FT200, PF6, MRP Need Date] = " &
[txtFT200, PF6, MRP Need Date] & "
AND [Actual Received Date On Dock] IS NULL ")





Brian in FT W. said:
John, there are three fields, 1. Quantity; 2. FT200, PF6, MRP Need Date;
3.
ACTUAL RECEIVED DATE ON DOCK

Fields 2 and 3 are "date" fields.


John Vinson said:
I would like to create a box on an intro form that show the results of a
sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON
DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6) to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it can't
have
a received date if the part has not been received)

Any help would be appreciated
Click to expand...

I'm not actually certain what you mean by "based on FT200, PF6" - but
guessing that these are fields which identify the records to be
summed, and that they are Number fields displayed on the form in
textboxes named txtFT200 and txtPF6, try setting a textbox's control
source to

=DSum("[QUantity]", "[your-table-name]", "[FT200] = " & [txtFT200] & "
AND [PF6] = " & [txtPF6] & " AND [Actual Received Date On Dock] IS
NULL AND [MRP Need Date] < #" & Date() & "#")


John W. Vinson[MVP]
Click to expand...
Click to expand...
 
Still not working...this is what I entered.

DSum("[Qty]", "[LAB SADS wo Harris]", "[FT200, PF6, MRP Need Date]" = "
<Date() = AND [Actual Received Date On Dock] IS NULL ")

Want to show the total quantity of parts that are late. The 'late date' is
determined by the FT200 need date. The way I know if the part has arrived is
if there is a date in the Actual Received Date on Dock (is null).

Thanks

JohnFol said:
So, modify John's suggesion to suit, ie

=DSum("[QUantity]", "[your-table-name]", "[FT200, PF6, MRP Need Date] = " &
[txtFT200, PF6, MRP Need Date] & "
AND [Actual Received Date On Dock] IS NULL ")





Brian in FT W. said:
John, there are three fields, 1. Quantity; 2. FT200, PF6, MRP Need Date;
3.
ACTUAL RECEIVED DATE ON DOCK

Fields 2 and 3 are "date" fields.


John Vinson said:
On Wed, 25 May 2005 15:24:02 -0700, "Brian in FT W."

I would like to create a box on an intro form that show the results of a
sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON
DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6) to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it can't
have
a received date if the part has not been received)

Any help would be appreciated

I'm not actually certain what you mean by "based on FT200, PF6" - but
guessing that these are fields which identify the records to be
summed, and that they are Number fields displayed on the form in
textboxes named txtFT200 and txtPF6, try setting a textbox's control
source to

=DSum("[QUantity]", "[your-table-name]", "[FT200] = " & [txtFT200] & "
AND [PF6] = " & [txtPF6] & " AND [Actual Received Date On Dock] IS
NULL AND [MRP Need Date] < #" & Date() & "#")


John W. Vinson[MVP]
Click to expand...
Click to expand...
Click to expand...
 
You have a typo

"[FT200, PF6, MRP Need Date]" = " Date() = AND [Actual Received Date On
Dock] IS NULL ")

should be

"[FT200, PF6, MRP Need Date] = " & Date() & " AND [Actual Received Date On
Dock] IS NULL ")



Brian in FT W. said:
Still not working...this is what I entered.

DSum("[Qty]", "[LAB SADS wo Harris]", "[FT200, PF6, MRP Need Date]" = "
<Date() = AND [Actual Received Date On Dock] IS NULL ")

Want to show the total quantity of parts that are late. The 'late date' is
determined by the FT200 need date. The way I know if the part has arrived
is
if there is a date in the Actual Received Date on Dock (is null).

Thanks

JohnFol said:
So, modify John's suggesion to suit, ie

=DSum("[QUantity]", "[your-table-name]", "[FT200, PF6, MRP Need Date] =
" &
[txtFT200, PF6, MRP Need Date] & "
AND [Actual Received Date On Dock] IS NULL ")





Brian in FT W. said:
John, there are three fields, 1. Quantity; 2. FT200, PF6, MRP Need
Date;
3.
ACTUAL RECEIVED DATE ON DOCK

Fields 2 and 3 are "date" fields.


:

On Wed, 25 May 2005 15:24:02 -0700, "Brian in FT W."

I would like to create a box on an intro form that show the results
of a
sum
function.

Fields: Quantity; FT200, PF6, MRP Need Date; ACTUAL RECEIVED DATE ON
DOCK

Want the Sum of the total quantity that is late (based on FT200, PF6)
to
need date; the ACTUAL DATE RECEIVED would need to be null (ie, it
can't
have
a received date if the part has not been received)

Any help would be appreciated

I'm not actually certain what you mean by "based on FT200, PF6" - but
guessing that these are fields which identify the records to be
summed, and that they are Number fields displayed on the form in
textboxes named txtFT200 and txtPF6, try setting a textbox's control
source to

=DSum("[QUantity]", "[your-table-name]", "[FT200] = " & [txtFT200] & "
AND [PF6] = " & [txtPF6] & " AND [Actual Received Date On Dock] IS
NULL AND [MRP Need Date] < #" & Date() & "#")


John W. Vinson[MVP]
Click to expand...
Click to expand...
Click to expand...
 
You have a typo

"[FT200, PF6, MRP Need Date]" = " Date() = AND [Actual Received Date On
Dock] IS NULL ")

should be

"[FT200, PF6, MRP Need Date] = " & Date() & " AND [Actual Received Date On
Dock] IS NULL ")
Click to expand...

Thanks for the catch, John! Actually, though, since this (horribly
misnamed) field is a Date/Time field, Wibble probably also needs #
delimiters:

"[FT200, PF6, MRP Need Date] = #" & Date() & "# AND [Actual Received
Date On Dock] IS NULL ")


John W. Vinson[MVP]
 
Back
Top