Hello I upsized to sql server from my mdb file to create adp file. Some queries have failed, one of them is this, can anyone help with the syntax please? Thanks!!!
FindContacts <- the name of the query in the mdb file
Failed to upsize. Attempted to use SQL:
CREATE FUNCTION FindContacts (@Forms_Switchboard_Salespersons varchar (255)
, @Forms__Find_Contacts_by_Date_R varchar (255)
, @Forms__Find_Contacts_by_Date_R varchar (255)
)
RETURNS TABLE
AS RETURN (SELECT tblcontact.ContactID, tblcontact.Prefix, tblcontact.FirstName,
tblcontact.LastName, tblcontact.Alias, tblcontact.ReadAdminComments, tblcontact.intlphone,
tblcontact.addressgood, tblcontact.AdminComments01, tblcontact.AdminComments02,
tblcontact.AdminComments03, tblcontact.dateofnextactivity, tblcontact.lastaccessed,
tblcontact.admincommentsupdate, tblcontact.Communication, tblcontact.Promotion, tblcontact.Weather,
tblcontact.prodqualif, tblcontact.Company, tblcontact.Country, tblcontact.Street, tblcontact.Apartment,
tblcontact.City, tblcontact.State, tblcontact.Zip, tblcontact.HomePhone, tblcontact.WorkPhone,
tblcontact.AlternatePhone, tblcontact.Fax, tblcontact.SourceCodeID, tblcontact.LeadCodeID,
tblcontact.LeadPotential, tblcontact.SalesPersonComments03, tblcontact.SalesPersonComments02,
tblcontact.SalesPersonComments01, tblcontact.Email, tblcontact.SalesPersonID, tblcontact.DateEntered,
tblcontact.Language, tblcontact.ContactTypeID, tblcontact.BrandID, tblcontact.PianoType,
tblcontact.FinishID, tblcontact.LowPrice, tblcontact.HighPrice, tblcontact.TradeIn,
tblcontact.TradeInDescription, tblcontact.Referral, tblcontact.Size, tblcontact.BuyorSell, tblcontact.Notes,
tblcontact.Status, tblcontact.AdminComments04, tblcontact.SalesPersonComments04,
tblcontact.SalesInvoiceNumber, tblcontact.SalesPersonID2
FROM tblcontact
WHERE (((tblcontact.SalesPersonID)=@Forms_Switchboard_Salespersons) And
((tblcontact.DateEntered) Between @Forms__Find_Contacts_by_Date_R And
@Forms__Find_Contacts_by_Date_R)))
^^^^^^^^
Why did it fail to upsize?
FindContacts <- the name of the query in the mdb file
Failed to upsize. Attempted to use SQL:
CREATE FUNCTION FindContacts (@Forms_Switchboard_Salespersons varchar (255)
, @Forms__Find_Contacts_by_Date_R varchar (255)
, @Forms__Find_Contacts_by_Date_R varchar (255)
)
RETURNS TABLE
AS RETURN (SELECT tblcontact.ContactID, tblcontact.Prefix, tblcontact.FirstName,
tblcontact.LastName, tblcontact.Alias, tblcontact.ReadAdminComments, tblcontact.intlphone,
tblcontact.addressgood, tblcontact.AdminComments01, tblcontact.AdminComments02,
tblcontact.AdminComments03, tblcontact.dateofnextactivity, tblcontact.lastaccessed,
tblcontact.admincommentsupdate, tblcontact.Communication, tblcontact.Promotion, tblcontact.Weather,
tblcontact.prodqualif, tblcontact.Company, tblcontact.Country, tblcontact.Street, tblcontact.Apartment,
tblcontact.City, tblcontact.State, tblcontact.Zip, tblcontact.HomePhone, tblcontact.WorkPhone,
tblcontact.AlternatePhone, tblcontact.Fax, tblcontact.SourceCodeID, tblcontact.LeadCodeID,
tblcontact.LeadPotential, tblcontact.SalesPersonComments03, tblcontact.SalesPersonComments02,
tblcontact.SalesPersonComments01, tblcontact.Email, tblcontact.SalesPersonID, tblcontact.DateEntered,
tblcontact.Language, tblcontact.ContactTypeID, tblcontact.BrandID, tblcontact.PianoType,
tblcontact.FinishID, tblcontact.LowPrice, tblcontact.HighPrice, tblcontact.TradeIn,
tblcontact.TradeInDescription, tblcontact.Referral, tblcontact.Size, tblcontact.BuyorSell, tblcontact.Notes,
tblcontact.Status, tblcontact.AdminComments04, tblcontact.SalesPersonComments04,
tblcontact.SalesInvoiceNumber, tblcontact.SalesPersonID2
FROM tblcontact
WHERE (((tblcontact.SalesPersonID)=@Forms_Switchboard_Salespersons) And
((tblcontact.DateEntered) Between @Forms__Find_Contacts_by_Date_R And
@Forms__Find_Contacts_by_Date_R)))
^^^^^^^^
Why did it fail to upsize?
