By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,704 Members | 1,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,704 IT Pros & Developers. It's quick & easy.

Access Query "?".. Need Help

P: 21
Hello Every 1:

I Have this query:

Tran Date Total Tran Per Day
200
0000 4
0710 38
0711 78
0712 15
0713 3
0714 16
0715 14
0717 8
0718 20
0719 1
0721 3
0722 3
0723 1
0724 15
0725 24
0726 17
0727 3
0728 29
0729 13
0730 13
0731 10
0801 18
0802 12
0805 3
0806 1
0808 4
0809 44
0813 12
0814 4
0815 22
0816 9
0818 6
0819 6
0820 4
0821 21
0822 39
0823 38
0824 20

I would like to total it by week ( i meen by -7)

Is there any way to do that.. by the way this quer already grouped by Tran Date
If you need anymore Info let me know..
Thanks in advance..
Regards
Iehab
Sep 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: 21
No ! Knows..

Thanks anyway I will never vist this page again..

Iehab
Sep 10 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.