Perhaps I was not clear, let me post the code.
CREATE VIEW dbo.vwImport
AS
SELECT dbo.tblSHOrderItems.dteShipped, dbo.tblSHOrderItems.txtInvNum, dbo.tblSHOrderItems.txtSuffix, dbo.tblSHOrdHead.txtCustomerPO,
SUM(dbo.tblSHOrderItems.intQuantity * dbo.tblSHOrderItems.curPrice) AS subtotal, dbo.tblSHOrdHead.curTaxAmt, dbo.tblSHOrdHead.pk,
SUM(dbo.tblSHOrderItems.intQuantity * dbo.tblSHOrderItems.curPrice) + dbo.tblSHOrdHead.curTaxAmt + dbo.tblSHOrdHead.curFreight AS grandtotal,
dbo.tblSHOrdHead.curFreight, dbo.tblSHOrdHead.txtCustnum
FROM dbo.tblSHOrderItems INNER JOIN
dbo.tblSHOrdHead ON dbo.tblSHOrderItems.FKOrdHead = dbo.tblSHOrdHead.pk
GROUP BY dbo.tblSHOrderItems.dteShipped, dbo.tblSHOrderItems.txtInvNum, dbo.tblSHOrderItems.txtSuffix, dbo.tblSHOrdHead.txtCustomerPO,
dbo.tblSHOrdHead.pk, dbo.tblSHOrdHead.curTaxAmt, dbo.tblSHOrdHead.curFreight, dbo.tblSHOrdHead.txtCustnum
I need to extract a date that is there without the time indication so all items on an invoice are grouped together.
"The grass is always greener over the septic tank." ~Leaf