I have a small app im working on that allows users to input data into an access database. This data represents incoming and outgoing items. Currently, the user can input all incoming and outgoing transactions, but I haven't been able to set them up to cancel each other.
What I would like to do is run a query that looks something like
Select top "variable" from tablename where type ="variable2"
then I would like to run another query on this query which looks like
select name, name SUM(name) As sumofname from "previous query" Group by name
I can write and get either of these queries to run, but I can't figure out how to use the dataset the first one provided to base the second one.
Any help would be appreciated