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.