Search results

I have a main form [Job Quote Form 10-2205] and I am trying to add a command button to open up [Job Process Form-MKD] and have the [Job Process Form-MKD] open up and only show the records that match a certain field, in this case what I call "JobTrackNo" in the [Job Process Form-MKD]. (see...

Thanks, Paul! Actually, I took a break and it finally came to me....all I had to do was put =" " in the criteria field and I got the results I wanted. I knew it had a simple answer! lol :D

I have searched the Query forum for quite awhile and can't seem to find an answer to this question, even though it seems pretty easy, I can't figure a way to do it.:banghead: I am just querying a single table, no relationship involved with another table. As you can see form the attached...

Thank you for the suggestion, however, when I run the query with this statement iif(Len(zip) = 12,Mid([ZIP],2,InStr(1,[ZIP],"-")-2),Mid(zip,2,5)) the result is every ZIP field is update to "ip" for some reason, as per attached (.jpg)

Still getting the same result. Please look at the (2) .jpg's I attached, the original and Step 2. As you can see when I enter your suggested command Mid([ZIP],2,InStr(1,[ZIP],"-")-2) in the Update Field of the query, the result of the query is perfect IF the original zipcode was...

I thought I had solved my initial problem of removing the apostrophe character for each zip code field. Most of the fields have data that reads '12345-1234'. I want to remove each (') character and the "-1234" so I end up with a zipcode of 12345. I created 2 queries for this process. I first...

I appreciate the advice, Simon. I will keep that in mind..... :)

Worked like a charm! thank you very much :)

Still new to this game.....where do I make this change? In the query itself? thanks for the help....Mark

Is there anyway to enable a query that pulls up just the basic information from a table and then click on the primary key field to open up a form I have created that contains all the information in a table in a more user friendly form that I created. The two images attached show the data...

I have some queries that pull data from one table and other queries that pull data from two related tables. In both cases, how do I prevent the data from being changed after the queries results are displayed? I know I could make a form and lock each field so it couldn't be changed, but I was...

Thanks for the idea! It seems to have worked perfectly! :D

I am trying to copy notes from one table to another table where a condition has to be met and I can't figure out how to do that in an APPEND query.:banghead: Each record has a unique number that comes into my Initial Table in my Access database from a construction program I download. In...

I have a subform which tracks all the notes our personnel have entered in a specific project (which is the main form). The issue is that I want the most current note to show in the subform when the project is "opened up". The underlying query for the subform has the [DATE] field sorted on...

Thank you for this info! Just one question, since the field currently has 10 characters in it, i.e. 2014123456, and there are 6 characters after the original 2014 should the formula be: Left([field],4) & "00" & Mid([field],6) Just want to make sure I get this right this time! :) Thank you...

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