Weekly Totals

[bionicman]

I am trying to obtain weekly totals on a report. what i have now, is a monthly report that will display totals from a yes/no checkbox, based on the date range that i enter. I need to have my query display my results weekly based on the ranges i would enter, but i need them to display on one page instead of just printing 4 pages.

Is there a way i could input the different date ranges and have them all display on one page?

EX:
Week 1 totals: (data)
Week 2 totals: (data)
Week 3 totals: (data)
Week 4 totals: (data)

Thanks in advance,
Dennis

 

[Shadez]

dlookup ?

 

[bionicman]

can you explain please? I have not used Access in a long time, and don't remember much of it.

Thanks

 

[Shadez]

dLookup is a command allowing you to run a query/lookup a value and place that data on a control.

For more info look in the help

 

[Rich]

Use a totals query and group by week

 

[bionicman]

Can you give me a little more information on the grouping by weeks?

I have a query that gives me the totals now, it asks me for the beginning and ending dates of the month, then gives me all the information. how would i go about seperating that into weekly? the only thing i could think of was to have it ask me the beginning and ending dates of the week 4 times (4 weeks in a month)..... but i am not sure how to have it pull the correct data when doing something like that.

thanks for the help!

 

[Shadez]

I would use dlookup, since you already have the query

Deffinition:-

DLookup(expr, domain[, criteria])

The DLookup function has the following arguments.

Argument Description 
expr An expression that identifies the field whose value you want to return. It can be a string expression identifying a field in a table or query, or it can be an expression that performs a calculation on data in that field. In expr, you can include the name of a field in a table, a control on a form, a constant, or a function. If expr includes a function, it can be either built-in or user-defined, but not another domain aggregate or SQL aggregate function. 
domain A string expression identifying the set of records that constitutes the domain. It can be a table name or a query name. 
criteria An optional string expression used to restrict the range of data on which the DLookup function is performed. For example, criteria is often equivalent to the WHERE clause in an SQL expression, without the word WHERE. If criteria is omitted, the DLookup function evaluates expr against the entire domain. Any field that is included in criteria must also be a field in domain; otherwise, the DLookup function returns a Null.

so set the control source of a text box to something like this

=Dlookup("[TotalValueField]","[YourQuery]","[TheDate] >= [startofweek] and [Thedate] <= [endofweek]")

 

[bionicman]

i think i am getting in over my head here i am gonna try to figure it out though, thanks for the help!