#### Russ At Index

##### Well-known Member
Hi,

Newbie to Access i am afraid, but so far so good !

I need to know if this is possible:

I have a receiving form which an operator will key the
total number of units received against the purchase order.
We do have a "buffer" when receiving of 10% + or - the shipment total.

I would like to have a flag to state whether the keyed received qty meets the
buffer criteria !!!!

Is this possible ??

Russ

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Yes. Because you can go 10% under or 10% over the requested quantity, then find the 10% amount (multiple .1 times the requested amount) and add that amount to the requested amount, save that as HighEnd, subtrate that amount from the requested amount, save that as LowEnd. Then compare with the amount received. If lower than the LowEnd, or higher than the HighEnd, give the operator a MsgBox with the message you want the operator to see.
HTH,

Hi Vic,

Thanks for the insight as to how i can acheive my target
regarding qty descrepancies.

As a newbie to Access and its intricate workings, could
elaborate on HighEnd / LowEnd please

Slightly cvonfused ( its early here in theUK !! )

Many Thanks

Russ

Russ,
I understand confusion, as I don't know where you want this flag of Over/Under, or what you plan on doing with it once you have it. You asked for some elaboration, but my answer fit the amount of information you have provided.
So far we know that you have a form for receiving material against a PO, you can accept a 10% + or - amount, and you want a flag if the amount received is outside this range.
So, if the PO ordered 1,000 units, my suggestion says to multiply 1,000 by .1. The answer will be 100. Then add 100 to 1,000. The answer is 1,100. So this is the HighEnd. The subtract 100 from the 1,000. The answer is 900. So this is the LowEnd. Then you compare these to values (HighEnd and LowEnd) to the received quantity. If the received quantity is lower than the LowEnd, or the received quantity is higher than the HighEnd, you set a flag (ReceivedQuantityOutOfRange) to True. Then you use this flag how ever you need to.

Replies
2
Views
96
Replies
1
Views
254
Replies
2
Views
679
Replies
9
Views
1K
Replies
1
Views
494

1,219,791
Messages
6,150,285
Members
450,949
Latest member
faizanmalik10

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back