Need help creating a weekly report

[myndphuc]

I am trying to use access to make a report from a pervasive/sql database. It has been quite some time since I have done anything with VB and Access so the point I am at now I am completely lost.

1.) I have a field that I need to filter on which checks to see if the record is active, inactive or canceled.

2.) I need to break the information up into weeks.

3.) After each week has been reported a weekly total needs to be summed up.

I could probably figure a lot of this out on my own but I'm working backwards I think .. I have the report portion pretty much done. I'm lost in where to start using VB code to massage the data. Thanks in adavance for any help anyone can offer me.

Christopher

 

[Lozere]

Start solving some issues by creating a Group (with the Grouping/Sorting dialog) based on the Week field (or a formula like =Week(Date_Field) if the field in your record contains the full date).
In the GroupFooter section created you can easily add some text boxes with =SUM (SomeField) to print the weekly totals

Your first issue (active, inactive or canceled) is not clear for me. What do you want: print 3 different reports for each category? Have a new page? Or????

 

[myndphuc]

The first question I had is the one that I am really stumbling on. Looking at the question again, I guess I did not make it clear enough. The report only needs to show open/active items. I do not use access often enough nor use access with an external DB so I am completely lost as how to filter the information for the report. So if I have a field called status, I only want to show fields that are equal to R (which would be an active/open record) and ignore the rest. Actually there is a second field I need to filter on. So the first field I need to filter I want it to be only show record if field1 is equal x, and if field2 is not equal to y. Hope this makes more sense now. My problem is not figuring out the expressions, it is where to apply this filter and how. I know I can filter the database itself but shouldn't I be able to write a filter specifically for this report, so that when the report is opened it filters the database and only shows records meeting the criteria... again Thank You in advance.

 

[Lozere]

Where is the filter parameters?
In the Data tab of the parameters of your report
You have a parameter called Filter where you write your condition:
Status="R"
and a second one called FilterOn to set to YES
Try once that way to be sure you're in the right way.

Then you can write a more complicated condition:
Status=&quot;R&quot; and Field1=X and Field2<>Y
Should work!