Recent content by alcorp

I am trying to use a query to remove blank cells that were created from another query. When I use the delete button at the top of the console screen for a delete query, it wont work. I tried using "" and Is Null but it neither work or gives me an error. I need to remove the blanks on the...

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...

Oh whoops. Supposed to be a numeric. Let me try again.

Okay awesome I found but I get this error when I run it. I left the ID column as Group by and I tried using other methods but still the same error. "Data type in mismatch in criteria expression." This is the SQL: SELECT APN.APN, Sum(APN.TAXFEE) AS SumOfTAXFEE FROM APN GROUP BY APN.APN;

Okay where is it? I clicked on my query results table to display the ID and the Taxfee columns. So I then click the create tab and I don't see Sigma/Summation symbol in the ribbon. (I looked at the other tabs and still nothing)

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...

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...

I wrote you a reply, idk if you got a get a notification from a non "quick reply" lol

I re-uploaded the file. I forgot carry the zeros over for a couple of fields for LActyTest. Basically I have to combine the MAPBOOK, PAGE, and PARCEL in LACtyTest which would equal a value called the APN. (APN from both tables are 10 characters long) In sheet the APN is provided. So in Query 1...

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...