Amen to that. I think the querying capability in Access is meh on a good day. I was asking originally because I was looking at a job posting where I...

Thanks Eirikur. I considered that... just seems there really isn't a good lightweight way in Access. =(

I wish there were an equivalent to ROW_NUMBER() in Access. Sooo handy in SQL Server!  Thanks!

For static information, just drop in a textbox... (Haven't you used SSRS for the past 2 years or so now?)
For the back side... might be a little trickier... You...

Maybe Jess Borland's example will help:
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/creating-mailing-labels-in-sql/

Typo in there somewhere... this works.  Basically, if you don't have a join between the tables (or explicitly state a CROSS JOIN), you get all possible combinations of the values...

Not sure if i have this right, but end goal is to have

red 1 year old car
red 2 year old car
red 3 year old car

Seems like if you had a parameter, you could hide the ones that aren't selected.
Just set the Visible property to a function.
Something like IIF(Parameters!ShowWhich=1,True,False) and modify them for...

Shame about not being able to use linked servers, because I think the answer might be to do a UNION of the two tables inside a stored procedure, and then...

Put a page break after the first tablix?

Without sample data, it's a lot harder to answer your question.  Since you're new, please read Jeff's article on how to post a question - he outlines how to ask...

Yuck. Sounds like a terrible idea.
What does your indexing on the table in question look like?

Brian Larson walks through a scenario like this in his SSRS 2012 book.
After some Googling...
http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/creating-mailing-labels-in-sql/