HELP!! Access Question!

[puffthomas]

Guys,

I'm in the process of going through an Access table with like 77,600 people. I've been instructed to take every 5th person out and throw them in an Excel spreadsheet. I've created a new column with and set it to AutoNumber, but how code it to provide me with every fifth doctor. Please, I reallllly would kill myself if I have to go through each 5 manually. I haven't been trained in SQL, but can someone just provide me with the code or what to do where I can get every fifth record (1, 5, 10, 15....)? Thanks and PLEASE HELP

 

[puffthomas]

anyone?

 

[PC Man Brian]

Sorry, can't help you there.

 

[office politics]

you need to setup a query to only show those records and then export to excel.

Microsoft Office Assistance: Enter criteria to retrieve certain records (MDB)


edit: you may be able to filter the table as well

 

[puffthomas]

CS,

that's how my question. how do i do that?

 

[office politics]

did it, start a new query in design view. open the table you need. double click the feild you want to show, the doc's name. enter the following expression for the criteria.

![NumberFeild] MOD 5 = 0

 

[puffthomas]

YO! You are that man! Thanks a billion CS. You saved me soooooooo much time. I really gotta give it up to you because I've asked like 25 of my friends today and no one had an idea. One guy is a DBA. Anyway, thanks a billion bro.

 

[office politics]

i aim to please, yw

 

[puffthomas]

Hey man, another question....Do you know how to take out specific text from a column? For example, there is an address field and in the field their might be a suite #. Well, I've now been told to add another column and to call that Address2. Is there anyway I can filter it out where I can pull out anything that says suite # in Address field1 and put it into a Address2 field? Sounds a bit complex, but it will again save me a billion hours of my time. Thanks for your help.