Access 2003 Report If Then question

[tsquared1518]

I am working in Access 2003, and trying to program a cell to put in ACCEPT or
REJECT, if the previous cell is between or outside the upper and lower limit
cells. Can anyone help me out with this?

 

[Gina Whipp]

tsquared1518,

The first problem would be you are thunking an Access table is like and
Excel spreadsheet on steriods... NOT. There are no *cells* in Access, there
are fields. Fields which are not programable. The are just there to hold
data. To do what you want you can either create a query and do it there or
do it on the form. Either way, normally you would not store this value in
any field (BUT there are exceptions to the rule).

The calculation to do this is...

IIf([FieldName] Between [LowerLimitFieldName] And
[UpperLimitFieldName],"ACCEPT","REJECT")

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[tsquared1518]

It is going into a Form I am trying to set up. My goal is to be able to open
the form, enter the data, and have it stored in the table. That way I can run
a query to search by the purchase order number, and have it pull up the table
with all the info I had entered. I will try this to see if it works. Thanks
for your help Gina.

tsquared1518,

The first problem would be you are thunking an Access table is like and
Excel spreadsheet on steriods... NOT. There are no *cells* in Access, there
are fields. Fields which are not programable. The are just there to hold
data. To do what you want you can either create a query and do it there or
do it on the form. Either way, normally you would not store this value in
any field (BUT there are exceptions to the rule).

The calculation to do this is...

IIf([FieldName] Between [LowerLimitFieldName] And
[UpperLimitFieldName],"ACCEPT","REJECT")

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am working in Access 2003, and trying to program a cell to put in ACCEPT
or
REJECT, if the previous cell is between or outside the upper and lower
limit
cells. Can anyone help me out with this?

 

[Gina Whipp]

Then to get it into the field you should put it in the After_Update of
LowerLimitFieldName and/or UpperLimitFieldName.

You're Welcome!
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

It is going into a Form I am trying to set up. My goal is to be able to
open
the form, enter the data, and have it stored in the table. That way I can
run
a query to search by the purchase order number, and have it pull up the
table
with all the info I had entered. I will try this to see if it works.
Thanks
for your help Gina.

tsquared1518,

The first problem would be you are thunking an Access table is like and
Excel spreadsheet on steriods... NOT. There are no *cells* in Access,
there
are fields. Fields which are not programable. The are just there to
hold
data. To do what you want you can either create a query and do it there
or
do it on the form. Either way, normally you would not store this value
in
any field (BUT there are exceptions to the rule).

The calculation to do this is...

IIf([FieldName] Between [LowerLimitFieldName] And
[UpperLimitFieldName],"ACCEPT","REJECT")

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" -
Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

I am working in Access 2003, and trying to program a cell to put in
ACCEPT
or
REJECT, if the previous cell is between or outside the upper and lower
limit
cells. Can anyone help me out with this?