Irs Income Tax Table_Know the proper syntax
Q.I found in the help file that I can use an expression to tell the DLookup function what I want to find, but there's no example of it. I have a form with a text box field with the name of the field in the table that I want to look up. So I want something like this for my DLookup control source: =DLookup([Forms]![Form1]![Deductions],"Federal Income Tax","[Federal Income Tax]![Income]>[Forms]![Form1]![Income]") The [Deductions] field on the form contains a number (1-10) and the fields in my IRS Income Tax table are named 1,2,3..10. I want to know the tax amount in the corresponding field. But I don't know the proper syntax. Help, please.
A.I think you are close. Try this: =DLookup([Forms]![Form1]![Deductions],"Federal Income Tax","[Income]>[Forms]![Form1]![Income]") or =DLookup([Forms]![Form1]![Deductions],"Federal Income Tax","[Income]>" & [Forms]![Form1]![Income]) Try - =DLookUp("[" & [Form].[Deductions] & "]","Federal Income Tax","[Federal Income Tax]![Income]>[Forms]![Form1]![Income]") You are looking up the FIELD in the table having the same name as the VALUE in your Deductions control so you need to wrap the value of Deductions in square brackets to force it to be interpreted as a field name.
Other Questions :
Irs Tax Table For 2006_Need for help
According to the Quickbooks PRO 2006 FAQ, it is acceptable to install the single user version on up to 20 machines, as long as only copy is used at a time. My question has to do with the one time free Irs tax table download. If the quickbo...
I am looking for an Irs Tax Book for a new entrepeneuer.
I am looking for an Irs Tax Book for a new entrepeneuer. I am looking for information on what sort of expenses are tax deductible, and what expenses aren't. I'm also interested in information on what can be completely written off and what needs...
Respond now or wait to audit by IRS
Just before Xmas we got an audit by the IRS , notice of the 93 taxes. Due to prior commitments in Dec and Jan we have attempted to delay the actual audit to late Feb or Mar. The appointment clerk said to simply wait for the 30 day notice. Tod...
Looking for a 2006 chart comparing the IRS tax in various states
I'm looking to move and would like a 2006 table/chart comparing the IRS taxes in various states.I've "googled", tried Money magazine, financial websites, federal.org etc and can't find a simple chart or dropdown table with info such as: State Incom...
Reason For Irs Audit
I have some questions concerning taperecording an IRS audit. First of all, I understand that if you want to do that, you must give the IRS a 10-day advance notice that you intend to taperecord. What is the reason for this 10-day notice? Why ...