Share via

Access query giving errors I can't explain

Maxine Nietz 1 Reputation point
2025-03-28T21:48:57.7+00:00

I have a complex query (below)

 

INSERT INTO SCHEDULE ( SONo, CustomerID, CustomerName, OrigQty, BalDueQty, UpdatedOn, ReqDt, DueDt, PricePerLb, ActTotal, OrderDt, ShippingMethod, PONo, PartNoReqd )

_SELECT SOsWithoutMatchingSCHEDULE.SONo, dbo_Customer.CUS_CustomerID, dbo_Customer.CUS_CorpName, SOSShipQtyQuery2.OrigQty, SOSShipQtyQuery2.BalanceDueQty, Date() AS UpdtOn, dbo_SalesOrderDelivery.SOD_RequiredDate AS ReqDt, If(dbo_SalesOrderDelivery.SOD_RequiredDate

SQL Server Transact-SQL
SQL Server Transact-SQL
SQL Server: A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.Transact-SQL: A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
177 questions

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. MARIA TELLO 0 Reputation points
    2025-03-28T22:28:31.53+00:00

    The field “SOI_SOLineNbr” in the sql table “dbo_SalesOrderLine” is a Number LongInteger. It produces a number like 1 or 3.

    0 comments
  2. MARIA TELLO 0 Reputation points
    2025-03-28T22:30:41.1433333+00:00

    I Can't explain

  3. Olaf Helper 46,636 Reputation points
    2025-03-31T07:09:54.0133333+00:00

    I need an answer so I posted in both locations.

    With that less on information no one can even guess.

    Please post table design as DDL, some sample data as DML statement and the expected result.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.