Recent content by hockeyadc

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.