How to insert a new record in a database

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Taofi
    New Member
    • Sep 2023
    • 1

    How to insert a new record in a database

    I try to insert a new record but the error message says the number of query names and destination fields are not the same

    This are my field names
    ID, Budgeted, Actual, Status and Differences

    The new record i want to add using a query is this
    Output 5, 600, 765.3, over budget ane -165.30

    Whats the correct sql syntax for this in order to work anyone want to share
Working...