Today - 15 weeks ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Any help on this small problem would be greatly appreciated.

I have numerous pivotcharts set up from a query, but would like to make it
so that i can move on to the next task quickly.

The tables that they run off hold data that gets updated weekly.
The query takes into account all the info but i would like it to just do the
last 15 weeks.
The Field contains weeks in number format, eg .... 634, 635, 636, 637, 638,
639 etc.
Because i have set the pivot charts up already i would love not to add
another field.


thanks
 
Do you have a specific location in the database (either a table or a form
field) that stores the number associated with the current week? If you do,
good; If you don't, you should consider doing so, even if you have to update
this field manually. If I could see the query data, I could give you a little
better explanation of what you should do, but it sounds to me like you
basically need to add a criteria to the Weeks field of the query similar to
this:

Between (Tables/Forms).[Table/FormName].[FieldName] And
((Tables/Forms).[Table/FormName].[FieldName] -15)

This will tell the query to gather everything from the Weeks field within
the range of the current week to the current week minus 15 weeks. This is
also dependant on how your query is set up, however.
 
i tried but couldnt get it to work

between [RT Result Table].[Fill complete week] and ([RT Result Table].[Fill
complete week] -15)

but i think you mean i should add another table that stores the week number
and reference this. (i tried but failed again).

If i could add a field to the Main Form that the user input/select the
current week then that would be excellent

thanks for the help

Nicholas Scarpinato said:
Do you have a specific location in the database (either a table or a form
field) that stores the number associated with the current week? If you do,
good; If you don't, you should consider doing so, even if you have to update
this field manually. If I could see the query data, I could give you a little
better explanation of what you should do, but it sounds to me like you
basically need to add a criteria to the Weeks field of the query similar to
this:

Between (Tables/Forms).[Table/FormName].[FieldName] And
((Tables/Forms).[Table/FormName].[FieldName] -15)

This will tell the query to gather everything from the Weeks field within
the range of the current week to the current week minus 15 weeks. This is
also dependant on how your query is set up, however.

ashfire said:
Any help on this small problem would be greatly appreciated.

I have numerous pivotcharts set up from a query, but would like to make it
so that i can move on to the next task quickly.

The tables that they run off hold data that gets updated weekly.
The query takes into account all the info but i would like it to just do the
last 15 weeks.
The Field contains weeks in number format, eg .... 634, 635, 636, 637, 638,
639 etc.
Because i have set the pivot charts up already i would love not to add
another field.


thanks
Click to expand...
Click to expand...
 
Back
Top