Hi,
currently working on a few databases at present.
I have a conundrum I would like to resolve for all of them.
My initial issues of trying to use a crosstab as a subquery have been solved by just using a simple query using the summary feature provided by the query wizard.
So now, I have a subquery on a form that shows a staff name, and a tally of hours.
I would like to be able to retrieve that tally from the subquery using a button so that I can either send it to a variable, or dump it into a textbox on the parent form.
can I reference the first record and second column of a subquery the same as I could in a subform?
if so, can anyone suggest vba to do so?.
Please note I am using access 2007.
currently working on a few databases at present.
I have a conundrum I would like to resolve for all of them.
My initial issues of trying to use a crosstab as a subquery have been solved by just using a simple query using the summary feature provided by the query wizard.
So now, I have a subquery on a form that shows a staff name, and a tally of hours.
I would like to be able to retrieve that tally from the subquery using a button so that I can either send it to a variable, or dump it into a textbox on the parent form.
can I reference the first record and second column of a subquery the same as I could in a subform?
if so, can anyone suggest vba to do so?.
Please note I am using access 2007.