concatenate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a simple databse. 1 table 2 fields. In a form I want to create 3 fields.
1.) Field 1 is a user input field (user types in a number)
2.) Field 2 Is a drop down list of field 2 in table (decimals)
3.) Calculated field that combines field 1 & 2
Example
Field 1..User types in 6
Field 2..User chooses .25
Field 3..User sees 6.25

Is this doable??
And can field 3 then be used in another equation on the same form?

Appreciated your time
 
=[Field 1]&[Field 20]
0r
=[Field 1]&"."&[Field 20]
Or
If they are both number fields
=[Field 1]+[Field 20]

etc
etc
 
Back
Top