Search results

  1. A

    How to incorporate customers that buy from more than one product group into an Access

    ...Into an Access Database. For example, X company purchases products from the G10, S20, S35, S40, S30, O50, AND O70 product groups. Is there a way to incorporate this extra information into a the database? thanx in advanced!
  2. A

    How to limit a field in Access to only 4 categories and record free-form text

    can someone please help me with this? thanx!
  3. A

    what is wrong with this statement: SELECT TOP 3 ([Balance]) FROM [advertiser];

    I am trying to do a query to find the three highest balances in an access table. The outcome is below. the 185 and 90 are not the highest numbers in the table. what am i doing wrong? the file is attached. Query1 Query1 Balance 185 90 0 Also, How to do a query to find the...
  4. A

    How to calculate Commission for each ad rep on this query

    How to calculate Commission for each ad rep on this query? And then how can retrieve only those records where the commission is greater than 50.00 dollars? I have attached the file to my thread. The query is named: "commissions". Can someone please help me? thanx!
  5. A

    Criteria on my second table does not appears when i run two joined tables.

    Why the criteria on my second table does not appears when i run two joined tables in Access? I joined two tables and when I run it, only the criteria on my first table appears, but not from the second one. what did i do wrong? I have attached the file to my thread. The query named is...
  6. A

    Character found after end of sql statement SQL error

    I am trying to do a query to find the three highest balances in a access table? This is what i have on my SQL but it gives me this error: "Character found after end of sql statement" SELECT Table1.[Advertiser Number], Table1.Name, Table1.Balance, Table1.[Amount Paid] FROM Table1; SELECT TOP 3...
  7. A

    How to do a query to find the total balance and the amount paid for each person?

    Also, How can I do a query to find the three highest balances in a access table? I Am new with Access please help me! I attached the file with my thread.
  8. A

    How to do a query to find the three highest balances in a access table

    I have a table that I need to query the three advertisers with the highest balance. How can i do that?
Back
Top Bottom