Microsoft Office Forums - View Single Post - SQL problem condition on select

Thread: SQL problem condition on select

View Single Post

Old

03-19-2014, 03:53 AM

peterwmartin29 peterwmartin29 is offline

peterwmartin29 is offline

peterwmartin29 uses Windows 7 32bit

Windows 7 32bit peterwmartin29 uses Office 2010 32bit

peterwmartin29 uses Office 2010 32bit

Office 2010 32bit

Novice

The original poster

Join Date: Mar 2014

Posts: 1

peterwmartin29 is on a distinguished road

Default

SQL problem condition on select

Can someone please help me modify this statement I have been trying for hours

select "Material", COUNT (*) from "dbo"."FinishedGoods" group by "Material"

I have another column named "TimeStamp" I only want the records after a certain date in the count. I am new to infopath and sql

Please help

Reply With Quote