Submitting Data from an Expression to a Database

[Mullie21]

I'm relatively new to InfoPath, so this may be an easy question. Here's the
situation . . I have a form which calculates some basic financial metrics.
Gross Revenue, Total Cost, Gross Profit, etc. In my form:

Gross Revenue (user input)
- Total Costs (user input)
= Gross Profit (Expression calculates this value)

When I submit the form, I would like all three metrics to populate into the
database. The issue is that the Expression (Gross Profit) data is not
transferred to the database. Is there a setup that can fix this? I've also
tried looking into options with my Access database to see if I can calculate
the Gross Profit once the data reaches the database, but I haven't been able
to figure that out yet either.

Please note that this is all new to me, plus my VBA skills are extremely weak.

Any help is appreciated.

Thanks,

Chris

 

[Franck Dauché]

Hi,

Did you read this?:
http://office.microsoft.com/en-us/assistance/HA011199501033.aspx

Regards,

Franck Dauché

 

[Mullie21]

Thanks for your help Franck, but the information in that link is basic form
creation stuff. My question pertains to the specifics of Expression Boxes
and how the data derived in the Expression Box is transferred to the
database.

Thanks again,

Chris

 

[Franck Dauché]

OK Sorry, it is sometimes hard to tell from the initial post.

Why don't you use a textbox with a function:
right click on your textbox
Default Value \ Click on Fx
Insert Field or Group (Gross Revenue ) - Insert Field or Group (Total Costs )

Then Gross profit is strored in the DB like Gross Revenue and Total Costs are.

Does it make sense?

Regards,

Franck Dauché

 

[Mullie21]

Thanks. This is what I'm looking for. I understand what you are saying, but
when I right click on the textbox, I don't see 'Default Value' in my list of
choices.

If I click on Properties to go to the default value screen, I don't see
'Fx'. And if I try to enter a formula in the default value box, Infopath
won't take it because the default value has to be a number, it can't be a
formula.

Could you please provide me a little more detail on where you are going to
enter the formula?

Thanks for your support,

Chris

 

[Franck Dauché]

Hi,

Yes you are in the right spot Properties / Default Value / little fx button
on the right of the Value field. Don't type the fields, instead use the
"Insert Field or Group..." button.

Franck Dauché

 

[Mullie21]

The 'Fx' button doesn't appear there. I must be missing a Service Pack or an
upgrade of some sort. I'll let you know how it turns out after upgrade.

Thanks,

Chris

 

[Franck Dauché]

You need to run SP1 or SP2.

Franck

The 'Fx' button doesn't appear there. I must be missing a Service Pack or an
upgrade of some sort. I'll let you know how it turns out after upgrade.

Thanks,

Chris