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 lien at a foreclosure auction...
I went to a foreclosure auction today and it was revealed before the bidding started that the house had an IRS lien of $40k on it. Interestingly, many of the "locals" bid the price up to what I thought it was worth w/o this $40k lean. I assume ...
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...
Does anybody know if I can send my tax return to IRS with using mailing address or another service requiring signature?
Does anybody know if I can send my tax return to IRS with using mailing address or another service requiring signature?Simple answer,yes, slightly more complex answer Watch the date of sending. With US Mail, the post mark on Cert mail is the ...
Why doesn't the IRS publish free tax software?
Why doesn't the IRS publish free downloadable software for people to do their own taxes? Hey, they give out free tax forms (paper ones, that is), so why withhold software that would have many positive effects?That is an excellent question. Th...
IRS tax fraud by the Co$ - http://www.xs4all.nl/~xemu/fraud/
http://www.xs4all.nl/~xemu/fraud/ Is there somebody - ANYBODY - who can pursue this thing with the IRS in the US? It is the Co$ laundering money money from the US through the UK. This is tax-exempt money turned into purposes that are not tax ...