Search results

  1. L

    Counting fields showing certain data

    Hi everyone, I have a report that shows transactions. Each transaction is different, they are either "1035" or "IRA". I can count all transaction by just counting one field, which is the transactionID field by =Count([TransactionID]) In the report, I have these fields: - TransactionID ----...
  2. L

    Expression Builder question...

    I created a make table query that joins two tables together in relation to account numbers. The query works perfect except for one of the fields. When the query is ran... it will ask to enter a parameter... which is in text format. When the query is finished the table is created. The field...
  3. L

    How would i go by creating this query?

    Hello everyone, I have two tables, Reinvests and Trades: Reinvests table has the following fields: - Portfolio Code - Tran Code - Security Symbol - Trade Date - Settle Date - Quantity - Amount - mgr# Trades table has the following fields: - Portfolio Code - Start Date -...
Top Bottom