Can we multiply two fields from two different forms without using a query.
Example from one table the value and from the second table the VAT(in order
when the VAT changes
to amend only the VAT field)
When I try it I'm getting error message.
Message posted via http://www.accessmonster.com
Why not use an unbound combo box to select the VAT tax rate on 1 form. Then
you can multiply it in the AfterUpdate event of the combo. Alternatively it
the VAT combo is bound to the table, if you are not using a continuous form
or datasheet, you can just multiply the numbers as the contro...Calculate average based on specific time or date
I have data of travel time between 2 locations each day. There are
columns such as date, start time and end time in multiple columns.
How can I find the average of travel time on Monday, Tuesday, Wed etc
and the average of travel time if start time is between 7:00 to 7:30,
Thanks for the help,
I have come up with a suggestion. Basically, I took your "average" two
ways. One way would be to look at the Total Average for all days over time,
and the second would be to look at the individual days themselves.
Basically, the start and stop time can be Differenced ou...Market Value calculation
When viewing my total assests in either the accounts list
or portfolio manager views, why is the market value column
displaying the market value minus the contributions cost
in the totals? I have not found a way to display only the
market value including using custom views.
I am more interested in the total value of holdings at
this point than gains. Besides, gains has it's own column.
Can anyone point out where I may be missing something
here? Is the attempt to display market value futile,
stupid, worthwhile but currently broken, other?
...One field referencing multiple bookmarks
I have a document containing several bookmarks, each a new letter for
revision; A, B, C...G. For each new version of the document, a new field and
letter is entered by the responsible. This procedure is ok (for now) and
In the header of my document I would like the latest revision letter to
appear in a field.
How do I program my way out of:
Check if bookmarks until last filled is found
Clear field in header
Insert latest (last filled bookmark) revision
Any suggestions appreciated.
One possibility, assuming that you will use only single le...Calculating cells blanks
I am trying to write an "IF" formula that calculates when the cell contains info, and when blank refers to another cell for the calculation information. I keep receiving the FALSE message. What am I doing wrong
Thanks in advance
try something like
=IF(A1<>"",your calculation,other cell calculation)
> I am trying to write an "IF" formula that calculates when the cell
> contains info, and when blank refers to another cell for the
issue us? Essentially I need to be able to calculate two values, one
is addition and the second is multiplication. I am getting some
strange numbers. My code is at the bottom under the ------, here are
crmForm.all.estimatedvalue.DataValue = 10
crmForm.all.new_cfp_estrev_nextyr.DataValue = 10
crmForm.all.new_cfp_estrev_yrtwoplus.DataValue = 10
This should make totalestrev = 30,
Then its getting weird, I am taking the following formula (10/100)*30
= 270? Here 10 is the value selected from the drop down value, I
...Enter a value and calculate in same cell
Is it possible to enter a value in a cell and have a
calculation performed based on the entered value, within
that same cell?
A1 = [Enter the value] * 5
this is only possible with VBA using an event procedure. Is this a
possible solution for you?
> Is it possible to enter a value in a cell and have a
> calculation performed based on the entered value, within
> that same cell?
> A1 = [Enter the value] * 5
Depends on how advanced. I have done research and coding
in Access, so it won't be co...show warning when a calculated total<0
How can I detect the condition that occurs when a calculated field becones
negative? I would like to issue a warning message at that time.
That's enough information to give a specific solution...
Are you talking about a form, or a query, or a report?
What's the calculation?
Describe the value/s that constitute the calculation.
Please... more info...
Essentially though... what event/s would effect/change that calculation
Use those events to trigger an evaluation of the new value, and respond
...calculate swim times
How can I track swim event times - mm:ss.ms format? I need to go two digits
deep in the MS format. This is to be used to track swimmer's times and
Thank you all for your time and help.
Format the cells with
In article <46dGc.9460$Bv.firstname.lastname@example.org>,
"saladbar" <email@example.com> wrote:
> How can I track swim event times - mm:ss.ms format? I need to go two digits
> deep in the MS format. This is to be used to track swimmer's times and
> chart progre...How to calculate portfolio performance
I currently calculate my portfolio performance using the formula:
=(H2/H1)-100% (H1 is beginning value, H2 is current value)
I will soon begin making withdrawals from my investment account. What
formula would I use to account for money that is withdrawn? Using the
current formula it would be counted as a loss.
1/1/2008 value = $10,000.00
2/1/2008 withdraw $2,000.00
2/28/2008 value = $8,100.00
I made $100.00, not lost $1,900.00. So what formula do I use to correct
To compute your $100 profit, do as you would on paper: =H2-(H1-2000) That
formula comput...Preserving the "TO" field for outlook
You can preserve the "FROM" how do I preserve ( show mailbox name and
internet mailbox it came from) on the "TO" field. I need to know what mailbox
they are sending it to..
Sorry, I'm not sure I understand what it is you are trying to solve.
Can you explain it with an example perhaps?
"ibarr" <firstname.lastname@example.org> wrote in message
> You can preserve the "FROM" how do I preserve ( show mailbox name and
> internet mailbox it came from) on the "TO" field. ...Logic for Placing Multiple field Returns in a Cell
Looking for the logic to concatenate cells, however I need one of those cells
to duplicate X number of times:
Such as CONCATENATE(d1, b1, b3) B3 being the value I want to return
I would like my results to come out: 1244444444
Use the following UDF:
Function Mergit(a, b, c)
Mergit = a & b & c & c & c & c & c & c & c & c
> Looking for the logic to concatenate cells, however I need one of those cells
> to duplicate X number of times:
I have a form with a tab control at the bottom. The first tab
has just a single control named txtComment. The other two tabs
contain a different subform.
The main form is based on a table - Equipment.
Each subform is independent of the other and each is based on
a table with a 1-many relationship to Equipment.
These tables are Maintenance and Movements.
When moving from record to record, there is a delay before
each new record is displayed. During this delay, the status bar
displays the message "Calculating..." which then changes to
T...Automatic Mortgage Calculation
I am running MYM2003 SE Version 11.
I have set up my mortgage account as a loan with all of the information
regarding rate, term, amount, etc. I pay my mortgage to the bank from my
checking account online. When I prepare the transaction, I input the
Category as Loan Payment:Mortgage ( name of mortgage account).
The mortgage account collects the data associated with the transaction but
incorrectly calculations the amount of interest vs. principal. In fact the
calculation is also inconsistent. (i.e. January Payment Principle 700 vs.
1243.69, March Payment Principle (138.67). This requires m...Calculations #4
when I am calculating my totals, my sum is more than what
is listed. How do I make the necessary changes to reflect
the correct sum.
This might describe your problem:
In article <email@example.com>,
"Jessica" <firstname.lastname@example.org> wrote:
> when I am calculating my totals, my sum is more than what
> is listed. How do I make the necessary changes to reflect
> the correct sum.
Thanks for such ...Cannot see full email address in From field
If a message is forwarded, I cannot see the email address
from the original sender(s) or those CC'd. They show a
displayed name. Is this a setting on my client or is it
done on the sender's client?
BTW, this happens on Outlook 2000 and 2003.
...Calculate Sliding Scale Calculation
I need to be able to calculate a commission as follows:
Total Commission (0-$100, 5%)+($101-399, 10%)+(>$400, 15%)
This would calculate a different percentage for each of the ranges
above and then add them together. I hope I'm making myself clear
because I'm confused just writing this.
It seems like there should be a very easy way to do this in Excel.
Any assistance would be most appreciated.
In article <email@example.com>,
"Andy" <...Access Fields
Can you set up a field (yes/no) that can't be checked yes if another field is
checked yes? While tracking training classes, I was thinking about completed
and registered fields. If someone is registered for a class, the class can't
be completed. As of right now, you can click on either, but you could click
on both and not have an issue.
On Mon, 5 Nov 2007 11:01:01 -0800, pf wrote:
> Can you set up a field (yes/no) that can't be checked yes if another field is
> checked yes? While tracking training classes, I was thinking about completed
> and registered fields. If...Calculation in Smartlist Builder
Does anyone have any hints for writing a calculation in Smartlist Builder to
convert a string field to a date field? I've tried several formulas
including the CAST function, but haven't had any luck.
Hello Tami J
No you can cast it into date type in Smart List, what you can do is create a
datatype as date in sql server it self and show it in the smart list.
"Tami J" wrote:
> Does anyone have any hints for writing a calculation in Smartlist Builder to
> convert a string field to a date field? I've tried several formulas
> including...Suggestion field
Hello, does anyone know how they call the suggestion field that appears at the explorer bar when you type an address. Or appears when you double-click on a username field. I would like to create something like that; maybe someone knows how to do that. It's probably simple but because I don't know the exact English word for it, it's hard to find.
You might want to take a look at IAutoComplete. Here is an interesting
article that talks about it a bit.
"Woestenburg" <Woestenburg@discussions.micr...How to create a looking based on 3 fields
Can someone point me in the right direction with what I want to do:
I know how to use data validation to create drop downs which is phase 1.
How do I cause a result to occur based on what was chosen
Col A = (user chooses ABC)
Col B = 80 (because ABC was choosen)
Sheet 2 will have the 'list' to choose from, so it's got all the values
in a Column for the user to choose from.
Col A = ABC
Col B = $90
Let me know if I haven't explained what I want to archive correctly.
It sounds like you can use =vlookup() or =index(match()) to retrieve the
...Calculating gross when net is known
Frequent budget adjustments when the gross amount of the adjustment is know.
I need to calculate backwards for the tax burden to come up with the net
I am lost here usually you have your gross less your taxes = Your net
assuming gross is in a1, tax in b1(calculated based on 10% taxes) in c1 the
net will be
Now if you know your net to get your gross will be
0.90 comes from 1-0.10 taxes
> Frequent budget adjustments when the gross amount of the adjustment is know.
> I need to calculate backwards for the t...Formulas not calculating correctly
How do I get formulas to calculate correctly?
I have used the following simple formula -
where t20 = =IF(N20>100%,"0",K20-M20)
z20 = 917,000
n20 = 99.04%
When I do the math, it should total 3,668,000, yet my total in excel is
3,457,090. Why is excel calculating this incorrectly?
I think its rounding problem if type figures given into excel it calculates
3668000 I presume figures in row 20 are sums of ranges
> How do I get formulas to calculate correctly?
> I have used the following simple formula...Calculations
I am using the trial version of MS Money. I've been using Quicken for 10
years so I understand financial products. My question is does this product
calculate the difference between yesterdays stock or mutual fund prices
versus todays prices?
It appears that it does but if I go back to a day other than todays date and
try to see what the daily change is, there is no data other than the current
dates data. Plus over this past week-end, I kept seeing Fridays change on
Saturday and then on Sunday but only on Stocks and not Mutual Funds. If you
wish to contact me direct...Error while Calculating Checks
While calculating checks, the system hangs up on the same employee every time
and gives me this error message:
Unhandled script exception:
Inded 0 of array 'Federal Wage Array' is out of range in script
'UPR_CHK_CALC_Process_Pay_Record'. Script terminated
Anyone have any ideas what is going on?
Have seen this before. Remove the employee from the batch.
Then check the state tax code on the employee card, the
federal tax card and all of the pay code cards. Reset the
state code on all of those fields - then re-add the
employee to the batch and try to calcul...