INSERT TEXT FROM A CALCULATED FIELD IN A FORM TO A TABLE????

[Guest]

HI,
Can someone please tell me how to insert text that is calculated in a form
field to a table field???

Ex: [document #1]=[doc name]+" #"+[#]+" exp"+[exp]

where [document #1] is the calculated field...i want to insert this
calculated value into a field on a table HOW DO I DO THAT????

 

[fredg]

On Thu, 16 Jun 2005 13:57:01 -0700,

HI,
Can someone please tell me how to insert text that is calculated in a form
field to a table field???

Ex: [document #1]=[doc name]+" #"+[#]+" exp"+[exp]

where [document #1] is the calculated field...i want to insert this
calculated value into a field on a table HOW DO I DO THAT????

Why would you want to?

As long as you have the other fields stored in your table, any time
you need to get "Document #1" just use the same expression as above.

 

[Guest]

when i do a printout of all my records from the table, that wont come out, i
know theres a way i just need to know how....

On Thu, 16 Jun 2005 13:57:01 -0700,

HI,
Can someone please tell me how to insert text that is calculated in a form
field to a table field???

Ex: [document #1]=[doc name]+" #"+[#]+" exp"+[exp]

where [document #1] is the calculated field...i want to insert this
calculated value into a field on a table HOW DO I DO THAT????

Why would you want to?

As long as you have the other fields stored in your table, any time
you need to get "Document #1" just use the same expression as above.

 

[Rick Brandt]

when i do a printout of all my records from the table, that wont come
out, i know theres a way i just need to know how....

The don't print from the table. Put the expression in a query based on your
table and print from the query.

 

[Guest]

Can someone just tell me how to do it??

The don't print from the table. Put the expression in a query based on your
table and print from the query.

 

[Guest]

can someone just tell me how to do this???

On Thu, 16 Jun 2005 13:57:01 -0700,

HI,
Can someone please tell me how to insert text that is calculated in a form
field to a table field???

Ex: [document #1]=[doc name]+" #"+[#]+" exp"+[exp]

where [document #1] is the calculated field...i want to insert this
calculated value into a field on a table HOW DO I DO THAT????

Why would you want to?

As long as you have the other fields stored in your table, any time
you need to get "Document #1" just use the same expression as above.

 

[fredg]

On Fri, 17 Jun 2005 11:09:02 -0700,

can someone just tell me how to do this???

On Thu, 16 Jun 2005 13:57:01 -0700,

HI,
Can someone please tell me how to insert text that is calculated in a form
field to a table field???

Ex: [document #1]=[doc name]+" #"+[#]+" exp"+[exp]

where [document #1] is the calculated field...i want to insert this
calculated value into a field on a table HOW DO I DO THAT????

Why would you want to?

As long as you have the other fields stored in your table, any time
you need to get "Document #1" just use the same expression as above.

Make sure that the [doc name] , [#], and [exp] fields are included in
the report's record source.

Add an UNBOUND control to your report.
Set the control's Control Source to:
=[doc name] & " # " & [#] & " exp " & [exp]

Notice that I have used the & to concatenate the data not the +.