Search results

Yes, yes, I know they're horrific things but this is not a query for data entry purposes, it's solely for a report. That said, I just want, when the report is run, to be asked for a singular tax year to display the results for. Thanks the same, though, ~Chad

Does anyone know if there is a way to have Data Validation for a Parameter Query? I tried searching today on the issue but I couldn't quite find an answer. Of course, my jargon isn't quite perfect and so I might just not be searching for the right terms. Basically I wish to review my business...

Best/Worst Joke... Two cows are standing in a field. The first cow says to the second cow, "Hey, have you hear about that new mad-cow disease?" Second cow says, "What do I have to worry about? I'm a helicopter." Guaranteed to always get a groan with about 20 more in the wings, ~Chad

Solution stumbled upon... Hi, just thought I'd mention that I seem to have stumbled upon a solution. I decided to allow my first query to work off my [PayeeID] instead of link to my [Payee] name. So, when I put together my third query I established my relationship from my existing [PayeeID] to...

Anyone have an idea why I'm recieving an error to the extent of, a field I am requesting for my report supposedly exists in multiple tables?? Basically, my query/table setup is such that I have a table for enterting expense information [Expense]. On the [Expense] table can be found any number...

Hi! So, I have a table for expenditure logging ([Expense Logs]) and on that table is a Payee field. The payee is (currently) only a single-name field like SUBWAY, or WACHOVIA. It has been suggested to me that I place my PAYEE listings into a separate table on the instance that I might want or...

Thanks... Wow, it's funny--I originally had this set up with three distinctive queries combined in a 4th and then read something that I interpreted to mean I had gone down the wrong path (hence the many select statements). There are actually 6 different fields to be combined. If there are...

Alright, here's what's up... I'm attempting to create a report for my personal finances that basically re-creates a duplicate of my monthly credit statements for quick comparisons to my real credit statements for aberrations in charges. That means each set of data from each respective month has...

Hi -- So, I'm a bit new here to the Access world. I was previously using an inflexible excel spreadsheet to do act as a record for my various finances but have made the switch to access for a much more powerful interface. Unfortunately, though, with nothing more than a poor book and the...