Search results

  1. M

    Add new record from linked form

    Is there a way to link two forms by master and child fields so I can add new records from linked form?
  2. M

    Compare records in the same table

    I have a table with contract information. It's got Contract #, Customer ID, date contract was signed, quantity purchased. When customer makes purchase again system creates another contract with a new number. I need to compare each contract for the customer with the contract signed next time by...
  3. M

    Bi-Weekly payroll date

    I need to calculate payroll due date. Payroll can be weekly, biweekly and monthly. I used DateAdd function and was able to calculate weekly and monthly payroll date but I can't figure out how to calculate biweekly date. Can anyone point me to the right direction?
  4. M

    Query two tables with many-to-many relationship

    I have two tables Orders and Payments with many-to-many relationship. Two different orders can be paid with one check and one order can be paid with several different checks. To link Orders table with Payments table I use third PaymentsOrders Table which has following layout: PaymentsOrdersID...
  5. M

    Need help with tables structure

    Hi, I’m working on the database to reconcile stock trade and cash for retirement fund. We receive checks from our clients which we need to invest. These deposits are logged into database and clerk orders purchase of different funds. This is a contribution. If client wants his money back we sell...
Back
Top Bottom