G
Guest
I'm very new to Access and have been assigned a very complex issue (as least
to me). I'm hoping someone will be able to help me or point me in the right
direction.
I have a form that I enter data into, this in turn calls a display form that
has an underlying query to accept the parameters and filter to this data. My
issue is that they want a particular field totalled, but only based on the 4
parameter field entry results. Sometimes they want the value summed, other
times they want the maximum value of the field added to a grand total. But,
the query returns all lines that meat the criteria (as it should). Do I need
to create a subquery? VBA Code (which I really don't know much about)? I
tried creating a query using the group by clause but couldn't get to work.
If I'm not explaining my question clearly enough, please let me know.
Thank you for any guidance you can give.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...3b7f&dg=microsoft.public.access.modulesdaovba
to me). I'm hoping someone will be able to help me or point me in the right
direction.
I have a form that I enter data into, this in turn calls a display form that
has an underlying query to accept the parameters and filter to this data. My
issue is that they want a particular field totalled, but only based on the 4
parameter field entry results. Sometimes they want the value summed, other
times they want the maximum value of the field added to a grand total. But,
the query returns all lines that meat the criteria (as it should). Do I need
to create a subquery? VBA Code (which I really don't know much about)? I
tried creating a query using the group by clause but couldn't get to work.
If I'm not explaining my question clearly enough, please let me know.
Thank you for any guidance you can give.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/com...3b7f&dg=microsoft.public.access.modulesdaovba