Search results

I was hoping you could help me with recovering data from a corrupted database. I have a huge table with almost 600K rows and 140 columns. I went to Database Tools, Visual Basic, Tools, References. There was a broken utility file. I removed it by unchecking the box and closed and returned to my...

I was able to uncheck it, close and reopen and complete the update query successfully. I was also able to write the 2nd query based on the first query. Thank you so much, I've been having a lot of trouble with my tables and databases corrupting and I've been fixing it the hard way by...

The answer to #1 = no The answer to #2 = I followed your instructions and am receiving the following: "Your Microsoft Office Access database or project contains a missing or broken reference to the file 'utility.mda'."

I think my table is corrupt. Easy way to fix?

I received an error, "Undefined function 'Left' in expression".

Sorry, here is the error message: The expression you entered has a function containing the wrong number of arguments.

I'm trying to perform an update query based on an Iif statement. If the condition is met, then I want to map the left portion of the tax_zip for 5 characters and the same for the right hand portion of the taxp_zip for 4 characters. I'm getting errors, can you tell me where my error is...

Thank you Lagbolt but I was looking for something to use in an update query. I do not know VB.

Hi Lagbolt, Thank you for your response. I love working with data but have not done it to this level in Access. Don't worry about this request, we can close it, I've decided it is much easier to do this extraction in Excel and then import the results/new column back into Access. Maybe I was...

My question is that I need assistance with a formula to extract what I have written above. I am having a lot of difficulty with it so I have posted the question. It is definitely too technical for me. If it is too technical for this forum, please advise and disregard this request for...

I need to perform an update query in access to a column in the same table which is currently null/blank. I'm trying to extract residential legal descriptions from a string. I would like to extract the 'Lot' and 'Block'. Below is a good example of my data: BLK 1 LT 45 BLK 1 LT 46 ACS 0.3595 BLK...

I have a table where the zipcode holds 9 characters. I would like to perform an update query to add any leading zeros to the first set of 5 characters and then produce output including a dash: 99999-9999. I tried this, but getting "undefined function in expression" error: Update to...

Can you assist me in converting a checkbox to text? I need to do it two ways: 1. Checkbox on = X; Checkbox off = (null) 2. Checkbox on = Yes; Checkbox off = No Thankx a ton! Kelly

Thanks Alan.... so can I do an update query to accomplish this? So then in the 'update to', do I insert the following: Trim([ST_DIR1]) one for every data point?

I have a table, containing the following data points: ACCT_NUM ST_NUM1 ST_DIR ST_NAME1 ST_SUFFIX SUITE SITE_ADDR Using an update query, I want to concatenate and trim: ST_NUM1 ST_DIR ST_NAME1 ST_SUFFIX SUITE and place into the SITE_ADDR field, so that the data in SITE_ADDR looks like...

Sorry, here is the string I'm using in my query to create the new field for concatenated address: ConcAddr: IIf(Nz([ST_DIR1],"", [ST_DIR1], " ")) & Trim([ST_NAME1]) & " " & IIf(Nz([ST_SUFFIX],"", [ST_SUFFIX], " ")) & Trim[SUITE]

I'm trying to concatenate an address with trim and nz. I need to determine whether or not ST_DIR1 and ST_SUFFIX exist. If they do not exist, then I want the ST_NAME1 and SUITE to display if any, else the entire address (concatenated with spaces in between and no leading or trailing spaces)...

Both tables have the exact same number of rows.... 96406 I wasn't able to set a primary key... Access did say there were duplicates. Hmmm, maybe I do need multiple joins.... I'll take another look at the data. Thank you so much for your help. :) Since you asked, here's the SQL code for the...

I am hoping to get some assistance for MS Access append query. I have two tables with a one to one ratio, number of rows is 96406 in both tables. I have joined the tables by an Acct_Num. Simple right? I want to append to a table which currently has no rows. No matter how I join the tables...

Hello, my name is Kelly and I am from Fort Worth, Texas, USA. I used MS Access several years ago and not again until now. :)