Simple Calculated field wont work!

  • Thread starter Thread starter alecgreen
  • Start date Start date
A

alecgreen

Dear All

I am trying to calculate the Recommend Selling Price using the
following calculated field
RSP: [StandardCost]*[tblSystemData]![Markup] - But it wont work! - can
someone please put me right!

Many Thanks

Alec
 
alecgreen said:
Dear All

I am trying to calculate the Recommend Selling Price using the
following calculated field
RSP: [StandardCost]*[tblSystemData]![Markup] - But it wont work! - can
someone please put me right!
Click to expand...

Is the tblSystemData table included in the query?
 
Rick said:
alecgreen said:
Dear All

I am trying to calculate the Recommend Selling Price using the
following calculated field
RSP: [StandardCost]*[tblSystemData]![Markup] - But it wont work! - can
someone please put me right!
Click to expand...

Is the tblSystemData table included in the query?
Click to expand...

Er! No! I guess it should be - I dont seem to be able to relate it, in
my query
 
alecgreen said:
Rick said:
alecgreen said:
Dear All

I am trying to calculate the Recommend Selling Price using the
following calculated field
RSP: [StandardCost]*[tblSystemData]![Markup] - But it wont work! - can
someone please put me right!
Click to expand...

Is the tblSystemData table included in the query?
Click to expand...

Er! No! I guess it should be - I dont seem to be able to relate it, in
my query
Click to expand...

Well then, how would you expect Access to use the expression...

[tblSystemData]![Markup]

Presumably this table has more than one row. The only way to get the value of
the Markup field from the specific row that I assume you need you would have to
include the table in the query and join it to a field or fields in the other
tables.
 
Rick said:
alecgreen said:
Rick said:
Dear All

I am trying to calculate the Recommend Selling Price using the
following calculated field
RSP: [StandardCost]*[tblSystemData]![Markup] - But it wont work! - can
someone please put me right!

Is the tblSystemData table included in the query?
Click to expand...

Er! No! I guess it should be - I dont seem to be able to relate it, in
my query
Click to expand...

Well then, how would you expect Access to use the expression...

[tblSystemData]![Markup]

Presumably this table has more than one row. The only way to get the value of
the Markup field from the specific row that I assume you need you would have to
include the table in the query and join it to a field or fields in the other
tables.
Click to expand...

Thanks for your help! - A re-design required!
 
Back
Top