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 :
to Irs: Wheres My Refund
i sent on January 31, a 1040EZ federal return to sacramento and still Wait.I want to ask Where's my refund.? any ideas or comments? should i resend it (a copy) by certified mail or continue to try to call them? anyone else out there experienc...
Frequent Trading Increases IRS Audit Risk?
I have recently started doing more frequent trading of stocks, say 3 or 4 trades per week. This is not exactly day trading, and I certainly am not doing it with big bucks. But at the end of the year, that will be over 150 trades. My question: ...
OT: IRS back tax and land ownership
I need a question answered about IRS back tax and land ownership. Where do you think I could find the answer? (I would rather not talk to IRS.) The problem is this: I want to buy a small piece of land. The owner has not paid taxes in many yea...
Audit by Irs can stop ?
I am comfortable with the idea that any goverment can make an audit from IRS about what ever it wants, when it wants. With that thought as a given, my question is: As a practical matter, does the IRS routinely examine a taxpayer's bank or ...
Child Tax Credit by the IRS & Divorce
I am recently divorced, as of June 30th. The court awarded me all four children for tax purposes even though they live with my ex. My ex received a child tax credit check in the amount of $1,600 made out to both of us. She refuses to sign the c...