Best Practice for Getting Net Profit Sum

[Kevo]

Hi,
Sorry, it has been awhile and I have lost what little knowledge I had gathered using Access (if you dont use it you lose it!)

I have a simple table that includes

Description, Date Sold, Net Profit (this is calculated field that takes price sold - commission percent, shipping, etc...)

What I want is a display (textbox) on my main form that shows a running total for the current week of Net Profit
and also a way to manual retrieve a total for specific date range

Reason - I want to see the total at a glance all week....then run a report to cut a check (I am paying out Net Profit every Monday from previous SUN-SAT)

Hope this is easy to understand.



I need best practice and if possible actual code for getting the current week sum....I am having trouble using DatePart

Thanks,
Kevin

[ItsMe]

It may be easiest to display your results in a report. Report's have tools that are good for adding stuff up.

It sounds like you will need a form with some unbound controls formatted as Date. With this, you can have the user enter some date parameters. From there, you can use the variables and the BETWEEN operator in a query.
http://www.w3schools.com/sql/sql_between.asp
You may also want to use the SUM function in your query. You want to be careful using WHERE clauses or HAVING clauses with aggregate functions. For instance, the SUM function will do an entire table dump and then apply the HAVING clause. I usually run a separate query with a WHERE clause and then apply the function to the filtered results.