grr struggle !!! Need expert advice

[Gmio]

hey, i got this template from microsoft template online, and trying to modify a bit for my own experience and company

alright here is the problem:
1- Client try to record the customers detail ( It works well)

2- Client record how many items the customer sells per month (all good but doesnt add up the subtotal)

3- At the end of the month It prints the report for the customers( i think its ok)

4- Next month , different date and want to print the new month sales again( trying to figure out, i really need some help here)

i been playing with it the last few days, i still dont get a clue ;( can someone modify a bit cheers

file locate:
http://www.wikiupload.com/download_page.php?id=145860 , the download link is on the right middle section and click the download button

 

[Gmio]

oh forgot to say , i want this access database to print a monthly report(diffrent month) for the merchant so its show the gst, commission and item cost etc

many many thanks <3

 

[Simon_MT]

The problem with downloading templates is that you really need to understand the Access environment. Your problems are not unsolvable and I would suggest:

1) You create a Dialogue Form to handle your date Criteria and launch your reports form this form.

2) On your Report have Client Header and Footer and put a sum(YourField) into it.

We have to learn somewhere, most of us borrow code form time to time so do persevere.

Simon

 

[Gmio]

The problem with downloading templates is that you really need to understand the Access environment. Your problems are not unsolvable and I would suggest:

1) You create a Dialogue Form to handle your date Criteria and launch your reports form this form.

2) On your Report have Client Header and Footer and put a sum(YourField) into it.

We have to learn somewhere, most of us borrow code form time to time so do persevere.

Simon

i have been using this template for over the months and i like it, where can i look at the dialogue form and u mean i do all the calculation in the report instead of form?

 

[Simon_MT]

In my experience and I have to handle US and UK date formats this is the better approach to my previous attempts. No all my Reports have the calculations embedded into the underlying Query.

I also created a Table of Reports and call Dialogue Form using the ReportsID. All I'm trying to say this approach worked for me.

Simon