shamal Registered User. Local time Yesterday, 22:55 Joined Sep 28, 2013 Messages 86 Feb 21, 2016 #1 Hi.... Report shows sales during the period How are records show this week only Note that the week starts on Sunday and ends the day Saturday Attachments o.jpg 48.7 KB · Views: 87
Hi.... Report shows sales during the period How are records show this week only Note that the week starts on Sunday and ends the day Saturday
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 13:55 Joined May 7, 2009 Messages 20,350 Feb 21, 2016 #2 select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date)
select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date)
shamal Registered User. Local time Yesterday, 22:55 Joined Sep 28, 2013 Messages 86 Feb 21, 2016 #3 arnelgp said: select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date) Click to expand... Hi...... I hope the application on the attached example
arnelgp said: select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date) Click to expand... Hi...... I hope the application on the attached example
shamal Registered User. Local time Yesterday, 22:55 Joined Sep 28, 2013 Messages 86 Feb 21, 2016 #4 arnelgp said: select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date) Click to expand... Hi.... Report shows sales during the period How are records show this week only Attachments Example.accdb Example.accdb 428 KB · Views: 72
arnelgp said: select * from yourTable where Date_Sele Between dateadd("d",(datepart("w",date)*-1)+1,date) And dateadd("d",(datepart("w",date)*-1)+7,date) Click to expand... Hi.... Report shows sales during the period How are records show this week only
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 13:55 Joined May 7, 2009 Messages 20,350 Feb 21, 2016 #5 please review Query1 on attached db. Attachments Example(2).accdb Example(2).accdb 428 KB · Views: 84
shamal Registered User. Local time Yesterday, 22:55 Joined Sep 28, 2013 Messages 86 Feb 21, 2016 #6 Hi... I am thank you very much, great idea How can this month, records show., please.
arnelgp ..forever waiting... waiting for jellybean! Local time Today, 13:55 Joined May 7, 2009 Messages 20,350 Feb 21, 2016 #7 here again, view qrySalesThisMonth. Attachments Example(2).accdb Example(2).accdb 448 KB · Views: 88
