Search results

Glad to..... When I first developed this Access Database it was back in the late 1990's! At that point in time the 201400565333 numbers would have been imported into my database as 14- 565333. That is why I had to set the field up as a text field and no a number field. (I imported the numbers...

I have a text field with numbers like this: 2014556682 or 2014236781, etc. My problem is that I need to insert 00 between the 2014 and the last 6 numbers. :banghead: Any suggestions as to how I can do this. thank you in advance........Mark

How does one use the replace function in a query....sorry I don't have any formal training in Access.......

CJ, the problem is that the website I download the data from only allows me to download it in a .csv format. I can't directly import it into Access... Thx for your reply :)

I have been downloading .csv files from a construction website that we use to following projects as they develop. I import the file into Excel and then want to bring it into my database. The issue is with two fields I have that are numeric, however, when downloaded into Excel, the information in...

I am not new to Access programming, but most of what I have done has been on Access 97 and 2003. My firm is in the construction business so I developed an Access program that everyone in my firm uses to track construction projects. I am always looking for ways to improve the program and found...