Search results

I need to make some kind of loop, is that possible in access?

I'm adding a bunch of rows with data into a table, and one of my fields is "ID number", which is just basically number the row in consecutive order before duplicates are removed. How can I make a query that will do this? So for instance the query would fill in "1", "2", "3", etc. depending on...

Awesome man thanks alot

One after another is fine. Perhaps even better. Can you tell me how to accomplish this? Thanks

Is this possible? I have about 8 queries I'd like to just run at one time. Perhaps with a macro?

Thanks again man

Actually I have another question about it.. I ran the update for one criteria and that worked find, but what if I have another? Say I want the "No" to output a 2 on column 2 as well? Can I do both in one query?

Thanks alot man that was it! Great help.

Theres no way to do it? Basically I want to look data in column1 of a table, and if it says "Yes" then column2 I want to say "1". Theres no way to code this?

So I have an IIF statement that I ran and it outputs the data the way I want it to. The only thing I dont know how to do is how do I take the data/results I get from running the query and put it into a specific column in a table?

Thanks alot man that did the trick!

I actually figure it out now. Thanks I realized my issue lol

Ah, no I think this is where my problem is. I am looking for info that matches in the "Citytype" column to that of the "area" column in the table "Info2". Not neccasarily the words "Info2.area"

Yes they do

Yes CityTypes are equal to values in area of the table Info2. Ideally I would like to take the values once it finds them and put them into another column in Info2 as well.

I'm basically trying to perform a VLOOKUP in SQL but I can't seem to get it to work... heres the code I'm trying SELECT Cities FROM tblMetroAudCLcity WHERE Citytype='Info2.area'; Returns an empty table for me :-(

Sorry this is more like what I'm trying to do... INSERT INTO Table1 (Column2) SELECT Column 1 From [Table2] where Column3='[Table1].Column1'; When I do this it says it will append 0 rows of data and it doesn't work.

Thank you, I will try it soon but I have ran into another issue. I'm sure its pretty simple, here is what I'm trying to do: SELECT City from [Cities] where Cityname='[Datatbl].area'; Now I'm getting an empty table from this, I assume my method is incorrect. My ultimate goal is to take data...

I need to just have the rows that have unique emails and phone numbers. I can make each of these a key and run a query twice but then how do I remove the entire row which contains a duplicate? I'm sorry but I can't provide sample data for this as the data is confidential...

Hi all, I'm trying to check for duplicates in a table, and if found, delete the corrosponding row. There are several thousand records in the table however, so I'm also trying to run this as fast as possible. Any help would be great! Thanks!