Creating a field based on other fields

  • Thread starter Thread starter J. L.
  • Start date Start date
J

J. L.

I'm trying to create a report from either tables or queries.

I want to be able to have two fields of data in each record evaluated so
that I can produce data that's not in the field.

Example.

Field1 Field2 Field3
A1 B1 C1
A2 B1 C2
A3 B2 C3
A4 B2 C4

Field3 is generated from the results of Field's 1 and 2 and new data (not in
any table) is placed there.

If anyone knows how to do that I would appreciate it, as I'm under a
deadline.
 
For a simple expression, just have an unbound field on the report / form

ie
Control Source
=[FieldA] * [FieldB]
 
I'm afraid that both fields are strings and not numeric values, and I need a
new string generated based on what FieldA and B contain.
You definitely understand the problem, its just there are no numbers
involved, so how to I do it with words.


JohnFol said:
For a simple expression, just have an unbound field on the report / form

ie
Control Source
=[FieldA] * [FieldB]


J. L. said:
I'm trying to create a report from either tables or queries.

I want to be able to have two fields of data in each record evaluated so
that I can produce data that's not in the field.

Example.

Field1 Field2 Field3
A1 B1 C1
A2 B1 C2
A3 B2 C3
A4 B2 C4

Field3 is generated from the results of Field's 1 and 2 and new data
Click to expand...
(not
in
any table) is placed there.

If anyone knows how to do that I would appreciate it, as I'm under a
deadline.
Click to expand...
Click to expand...
 
Back
Top