Help me do this, urgent!

[smith]

I have to have the data transfered automatically in the fields.

1. Data in Field A= data in Field B* data in Field C/ 100.How to do this in
the "Forms"?

2. data in Field C= data in Field D+12. How to do this in the "Forms"?

2. If Data in Filed D> Field E or Field D > Field F, Then Show the
information of Table.How to do this in the "Queries"?



--

 

[Rick B]

One post per issue please. You should not post the same question in
separate newsgroups. If you feel a question belongs in more than one group,
post a COPY of it to other groups by entering multiple newsgroups when you
send the message. Then, if someone responds to one, the response will be
tied to all the groups.

This will prevent multiple people from wasting time answering a question
only to find it already answered elsewhere.

For more on proper newsgroup usage, see the following:

Netiquette FAQ
http://www.mvps.org/access/netiquette.htm

 

[BruceM]

Don't store calculations; perform them on the fly. Starting with the second
question, in an unbound text box on a form, set the control source to:
=[FieldD] + 12
For the first question, what you are calling Field C is a calculation based
on Field D, so use the calculation as part of another calculation to obtain
what you are calling FieldA. In an unbound text box, set the control source
to:
=[FieldB]*([FieldD]+12)/100
or maybe:
=[FieldB]*(([FieldD]+12)/100)
depending on just what calculation you need to perform.
Concerning the third question, you can create a calculated query field by
doing something like this at the top of a blank column in the query design
grid:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],do something,otherwise
do something else)
I have to be vague here because I cannot understand what you mean by "show
the information of Table".

 

[smith]

Thanks very much.

What I meant was that, it can show only on that condiction.

Don't store calculations; perform them on the fly. Starting with the
second question, in an unbound text box on a form, set the control source
to:
=[FieldD] + 12
For the first question, what you are calling Field C is a calculation
based on Field D, so use the calculation as part of another calculation to
obtain what you are calling FieldA. In an unbound text box, set the
control source to:
=[FieldB]*([FieldD]+12)/100
or maybe:
=[FieldB]*(([FieldD]+12)/100)
depending on just what calculation you need to perform.
Concerning the third question, you can create a calculated query field by
doing something like this at the top of a blank column in the query design
grid:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],do
something,otherwise do something else)
I have to be vague here because I cannot understand what you mean by "show
the information of Table".

I have to have the data transfered automatically in the fields.

1. Data in Field A= data in Field B* data in Field C/ 100.How to do this
in the "Forms"?

2. data in Field C= data in Field D+12. How to do this in the "Forms"?

2. If Data in Filed D> Field E or Field D > Field F, Then Show the
information of Table.How to do this in the "Queries"?

 

[BruceM]

I'm not clear if you are asking a question. If so, to what does "it can
only show" refer? Do you want to see an empty text box? Do you want a text
box or other control to appear or disappear?

Thanks very much.

What I meant was that, it can show only on that condiction.

Don't store calculations; perform them on the fly. Starting with the
second question, in an unbound text box on a form, set the control source
to:
=[FieldD] + 12
For the first question, what you are calling Field C is a calculation
based on Field D, so use the calculation as part of another calculation
to obtain what you are calling FieldA. In an unbound text box, set the
control source to:
=[FieldB]*([FieldD]+12)/100
or maybe:
=[FieldB]*(([FieldD]+12)/100)
depending on just what calculation you need to perform.
Concerning the third question, you can create a calculated query field by
doing something like this at the top of a blank column in the query
design grid:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],do
something,otherwise do something else)
I have to be vague here because I cannot understand what you mean by
"show the information of Table".

I have to have the data transfered automatically in the fields.

1. Data in Field A= data in Field B* data in Field C/ 100.How to do this
in the "Forms"?

2. data in Field C= data in Field D+12. How to do this in the "Forms"?

2. If Data in Filed D> Field E or Field D > Field F, Then Show the
information of Table.How to do this in the "Queries"?

 

[smith]

Sorry, I am not english native speaker.

Can the query result be showed when I run query on that condition?

I'm not clear if you are asking a question. If so, to what does "it can
only show" refer? Do you want to see an empty text box? Do you want a
text box or other control to appear or disappear?

Thanks very much.

What I meant was that, it can show only on that condiction.

Don't store calculations; perform them on the fly. Starting with the
second question, in an unbound text box on a form, set the control
source to:
=[FieldD] + 12
For the first question, what you are calling Field C is a calculation
based on Field D, so use the calculation as part of another calculation
to obtain what you are calling FieldA. In an unbound text box, set the
control source to:
=[FieldB]*([FieldD]+12)/100
or maybe:
=[FieldB]*(([FieldD]+12)/100)
depending on just what calculation you need to perform.
Concerning the third question, you can create a calculated query field
by doing something like this at the top of a blank column in the query
design grid:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],do
something,otherwise do something else)
I have to be vague here because I cannot understand what you mean by
"show the information of Table".

I have to have the data transfered automatically in the fields.

1. Data in Field A= data in Field B* data in Field C/ 100.How to do
this in the "Forms"?

2. data in Field C= data in Field D+12. How to do this in the "Forms"?

2. If Data in Filed D> Field E or Field D > Field F, Then Show the
information of Table.How to do this in the "Queries"?

 

[BruceM]

I'm doing my best to understand. It would help if you tell me whether you
tried performing the calculations as I suggested.

I often perform calculations in a query. For instance, I said that you
could use the following as the Control Source of an unbound text box:
=[FieldD] + 12

You can also perform that calculation in a query. In a new column in the
query design grid:
FieldA: [FieldD] + 12

In another column:
FieldC: [FieldB]*([FieldD]+12)/100

In another column:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],[FieldD],"")

This expression says that if FieldD > FieldE or FieldF, show FieldD,
otherwise show nothing. Only you can decide what needs to happen where I
have written "show FieldD" and "otherwise show nothing".

In any case, you can use the query as the Record Source for a form, and use
FieldA, FieldC, and NewField as the Control Source for text boxes on the
form. You can also run the query and look at the results in the query's
datasheet view.

Sorry, I am not english native speaker.

Can the query result be showed when I run query on that condition?

I'm not clear if you are asking a question. If so, to what does "it can
only show" refer? Do you want to see an empty text box? Do you want a
text box or other control to appear or disappear?

Thanks very much.

What I meant was that, it can show only on that condiction.

"BruceM" <[email protected]>
дÈëÏûÏ¢ÐÂÎÅ:[email protected]...
Don't store calculations; perform them on the fly. Starting with the
second question, in an unbound text box on a form, set the control
source to:
=[FieldD] + 12
For the first question, what you are calling Field C is a calculation
based on Field D, so use the calculation as part of another calculation
to obtain what you are calling FieldA. In an unbound text box, set the
control source to:
=[FieldB]*([FieldD]+12)/100
or maybe:
=[FieldB]*(([FieldD]+12)/100)
depending on just what calculation you need to perform.
Concerning the third question, you can create a calculated query field
by doing something like this at the top of a blank column in the query
design grid:
NewField: IIf([FieldD]>[FieldE] Or [FieldD]>[FieldF],do
something,otherwise do something else)
I have to be vague here because I cannot understand what you mean by
"show the information of Table".

I have to have the data transfered automatically in the fields.

1. Data in Field A= data in Field B* data in Field C/ 100.How to do
this in the "Forms"?

2. data in Field C= data in Field D+12. How to do this in the "Forms"?

2. If Data in Filed D> Field E or Field D > Field F, Then Show the
information of Table.How to do this in the "Queries"?