Search results

  1. L

    Counting fields showing certain data

    Ummm ok...
  2. 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 ----...
  3. L

    Expression Builder question...

    yes i wanted it to ask for a parameter... its wierd because i rewrote the query in 97 access the same way i did for 2000 access and that field comes out as a text field... but in 2000 access it comes out as binary... I want it to be in access 2000 because all the desktop in our department runs...
  4. 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...
  5. 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