Recent content by lmid

Thank you, I think this will work.

Thank you. I'm sorry I haven't responded, I cought a bug so I didn't get a chance to try your query yet.

Yes, I would like to show that individual rows that have a combined amount of over $x. I see that I can't use Group By but I don't know how to do it. I was trying multiple queries but I haven't been able to come up with anything that worked.

Thank you, but that won't work. If Trans_ID is added to group by, the sum will total by each trans_ID also. If I change the criteria to be HAVING sum([amount])=10, ID #1 won't show up.

Hi, I have a table Trans Amount Code Date ID Trans_ID $5 JL 5/13/06 1 5876 $5 JL 5/13/06 1 245 $6 DR 01/06/05 3 6535 The trans_ID is a unique number for each record. I would like to do the something like: select code, amount, date from...

Thank you! This looks like it will do the trick!

Thank you Duane, but that won't work in this situation. I don't always want to return records from all the tables. I don't even want to look in the tables that were not checked off in MyTables. It doesn't matter if after quering them no results would be returned, I can' t look in them at all...

I have the names of several tables in a table called "MyTables", each table name as its own record, together with a checkbox. I want to make a query that will return records ONLY from the tables where that table's record in MyTables is checked. Is this even possible? How can I go about doing...