Setting Quantity as a function

[anissw]

Hi. I have multiple conditional statements in order to define Quantity and Access only allows 255 characters for the expression builder. How do I setup my function to define quantity based on the multiple conditional statements I need to implement? The quantity field name I have is based on several other fields.

Thanks-

Anissa

 

[GregRun]

Can you post what you have so far so we can get a better idea of what you're trying to do?

 

[gemma-the-husky]

Hi. I have multiple conditional statements in order to define Quantity and Access only allows 255 characters for the expression builder. How do I setup my function to define quantity based on the multiple conditional statements I need to implement? The quantity field name I have is based on several other fields.

Thanks-

Anissa

I do not understand this.

Any field should not be dependent on other fields. One of the first rules of normalisation.

If you can evaluate quantity based on other fields, you do not need to store it.

however, assuming you have a transactions table, then the quantity should be a sum of certain transactions.

your issue will be the table design that leads you to have this complicated function, I am sure

 

[anissw]

Hi. Thanks for answering me. The tables are a bit complex in theory in which my calculation from the raw file is setup to calculate several different scenarios of order processing quantities (orders, addtl items, extra pkgs, etc.) So far, there are about 17 different fields that can be identified as quantity based on their Item ID (e.g. if ITEMID="I12345" then Quantity=field1, etc) from the calculated row(s). Since Access can allow 255 character in expression builder, I have run out of text. Please find attached the script I have. I have to apply more in and have run out of room for typing.

Thanks-

Anissa