Search results

  1. A

    Delete info from a query?

    Hi all, Okay I have 2 tables and I used queries to filter and delete the info off those tables. Now I combined the 2 tables by using a query which is query 1. What I found was a few cells that are blank cells. I tried creating another query based on query 1 from the 2 tables to try and delete...
  2. A

    How to remove duplicated ID but have them add up the values the ID represneted

    Hi, In access I queried my results and now I have to do this last step. I basically have an ID column and a tax fee column. I am trying to remove the duplicated ID numbers but if they are duplicated I need it to add up the tax fee column so I can have one ID with all the tax fees added up...
  3. A

    How to use two different formulas in a query depending on one value

    Hi! Okay i queried my results and I think I got what I need. The next step is to process the info so I can display the results. I am trying to use the expression builder but I am getting stuck. (if there are any other ways, I am open to them) So basically in a column I have value that is...
  4. A

    Duplicate data from two different fields

    Hi! First post! Also a noob. Maybe someone can help me on this problem since I am still new and I can't find anything clear, Anyways I've been trying to figure out a way to query duplicate data from two different fields from two different tables in the same access 2010 project. I first quried...
Top Bottom