PC Review


Reply
Thread Tools Rate Thread

Re: Week To date sales

 
 
Robert W. Storck
Guest
Posts: n/a
 
      5th Aug 2008
Test.




"gmenon100 via AccessMonster.com" <u24255@uwe> wrote in message
news:87047b17d2bca@uwe...
> Dear friends,
> I am working on access ADP with SQL back end
> I have a table with the following columns:
> Code#, OrdDt, Quantity, amount, Salesrep, Customer,
>
> I want to form a query / SP to show the following:
>
> Weekly:
>
> Code Mon Tue Wed Thu Fri
> Sat Sun TOTAL
> qty amt qty amt qty amt qty amt qty amt qty
> amt qty amt QTY AMT
>
> 7778 2 3000 4 322 7 9992 11 2828 3 847 83
> 3377 6 773 116 18616
> 5466 ...........
>
> Same for the monthly report and yearly.
>
> Can someone please advise how I can go with this?
>
> Thank you
>
> Gimen
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/For...erver/200807/1
>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I show day-of-week in 'Calendar' -> "Work Week" & "Week" SkwrHdz Microsoft Outlook Discussion 1 8th May 2009 03:50 PM
group sales by week and week number =?Utf-8?B?V2FubmEgTGVhcm4=?= Microsoft Excel Misc 7 7th Nov 2006 12:44 PM
Work week or week view advancing to next week =?Utf-8?B?ZnMwOQ==?= Microsoft Outlook Calendar 7 13th Oct 2006 09:29 PM
Compare last week sales to this week or last month to this month =?Utf-8?B?QmVydA==?= Microsoft Access Queries 2 11th Apr 2006 12:55 AM
total sales compared with year to date sales =?Utf-8?B?YmlubmllIHBpbGxhaQ==?= Microsoft Access Queries 0 2nd Feb 2005 12:25 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:05 PM.