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 :
No full information of income taxes ,is a reason to auditing by Irs
I really don't know any reasons the IRS is auditing to me. I just got a letter from the IRS. They reviewed my 1993 income tax and accordingto them I owed the $1100, this includes a penalty. It seems like they are right, but does this mean that ...
Link show the Us Irs 2005 Tax Table
I bought QBooks pro 2005. I do not plan to purchase the IRS Tax table service and I am happy with the one-time free update. Just exactly what is the process to obtain this free update? I tried to get the update yesterday 12/28/04 and all I got ...
Who has access to your tax information besides the IRS. Can anyone else see your taxes without our permission?
Who has access to your tax information besides the IRS. Can anyone else see your taxes without our permission?Even within the IRS only certain people are supposed to be able to see your tax records without your permission. All information is pr...
I went to the irs.gov site and looked at free efile.
I used to use telefile to file my 4868, automation extension for the form 1040. That has been discontinued. Now, we are supposed to use a free efile site. I went to the irs.gov site and looked at free efile. Most don't have 4868 and tho...
2006 TaxAct Irs Schedule - Problem
I've used TaxAct Deluxe for several years with no negative issues. In 2006, we sold a second home and incurred a $6,000 loss. TaxAct offers guided input for sale of a "main" home, not of a 2nd home - I tried inputting as if it was a main ho...