Search results

  1. A

    Self Populating fields based off primary key

    I have been trying to use the Dlookup function to make fields self populate after selecting the "property code" - which is the primary key - from a drop down list. I keep getting errors. Is the Dlookup function the right tool to use in this situation? If so, can somebody explain the components...
  2. A

    Creating unique rows in one column of query

    SELECT Prop_Mast_Tbl.[Property Code], Prop_Mast_Tbl.Resident, GL_SalesPayment_Tbl.[Transaction Amount] AS [SalesPayment_Tbl_Transaction Amount], GL_Gains_and_Loss_Tbl.[Transaction Amount] AS [Gains_and_Loss_Tbl_Transaction Amount], [SalesPayment_Tbl_Transaction...
  3. A

    Creating unique rows in one column of query

    CodeSalesPayment_Tbl_Transaction AmountGains_and_Losses_Tbl_Transaction AmountNet_Cash_Proceeds001EMP000318($100,000.00)$30,000.00($70,000.00)001EMP000318($100,000.00)$20,000.00($80,000.00) I'm a beginner here. Above is a portion of a query I created and I am trying to get the gains and losses...
Back
Top Bottom