G
Guest
Help - I want to return the following values in a form:
Most Current Sale by Agent
Month to Date Sales by Agent
Year to Date Sales by Agent
I am able to extract the most current sale however I can't seem to get the
correct sum when I get the correct date.
My problem also continues when I try to get the Month to Date and Year to
Date Sales Figures.
I have a subform in the main form that returns the most current sale.
Any suggestions would be helpful.
I have been away from access programming for a long time and I have searched
several of the boards but can't seem to find anything to help me.
Thanks in advance.
Most Current Sale by Agent
Month to Date Sales by Agent
Year to Date Sales by Agent
I am able to extract the most current sale however I can't seem to get the
correct sum when I get the correct date.
My problem also continues when I try to get the Month to Date and Year to
Date Sales Figures.
I have a subform in the main form that returns the most current sale.
Any suggestions would be helpful.
I have been away from access programming for a long time and I have searched
several of the boards but can't seem to find anything to help me.
Thanks in advance.