Re: Tax Reporting / Date & Time winnings Query for Pokertracker Ring G
My SQL is often limited to the Access translation of what I do in the "design" view of Access querys, but from what I can tell, that combined with the pivot table is going to be a good way to get your desired results especially considering your state tax issues (luckily, in VA, we're allowed to take the same deductions on the state return as we take on the federal).
My only constructive comment is I believe a full-blown pivot table may be a bit of overkill compared to a importing your session results and using a couple of array formulas in Excel, but in the end you will acheive the same results. There is likely a way you can acheive the same goals with VBA, perhaps in a UserForm you like, but that's probably a greater overkill than the pivot tables.
|