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 jobs thoughts please, no flames needed
I am considering a life-style change that includes a severe drop in earnings. I will not discuss my current situation. The life-style I am considering requires an estimated $36,000 USD per annum earnings. My questions are two: - if the net ...
Irs debt relief services
Once or twice a week, I see advertising for Irs debt relief services. They help you get back on your feet and stop your creditors from hounding you. They all claim to be a non-profit entity. I find them annoying. Since they advertise so much...
2006 Book Irs Tax is no longer applicable for donations
I remember a Book IRS Tax Law from Jan. 1, 2006 which says the standard tax writeoff for used car donation is $500. Anything worth more than $500 is limited to the gross proceeds from the actual sale of the vehicle by the non-profit organizat...
Received an Irs Form W-2 instead of 1099-MISC
I was employeed full time with company ABC for the first 3 months of Year 2003 and the then became self-empolyeed for 8 months. I was working as a Independent Contractor for the same company ABC. I asked the company to withhold my Federal, St...
Some advices about Audit By Irs
On a field examination, there was a audit by IRS is examining 2002 for a S Corp. IRS is also requesting copies of the 2001 tax return and the 2003 tax return. They are also requesting copies of the 2002 (1040) tax return for the single shareh...