HELP!! Access Question! - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 07-07-2005, 03:04 PM   #1 (permalink)
Newb Techie
 
Join Date: Jun 2005
Posts: 7
Send a message via AIM to puffthomas
Default HELP!! Access Question!

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 is offline  
Old 07-07-2005, 03:44 PM   #2 (permalink)
Newb Techie
 
Join Date: Jun 2005
Posts: 7
Send a message via AIM to puffthomas
Default

anyone?
__________________

puffthomas is offline  
Old 07-07-2005, 03:45 PM   #3 (permalink)
Super Techie
 
Join Date: Jul 2005
Posts: 262
Send a message via AIM to PC Man Brian
Default

Sorry, can't help you there.
__________________
PC Man Brian is offline  
Old 07-07-2005, 03:57 PM   #4 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

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
office politics is offline  
Old 07-07-2005, 04:06 PM   #5 (permalink)
Newb Techie
 
Join Date: Jun 2005
Posts: 7
Send a message via AIM to puffthomas
Default

CS,

that's how my question. how do i do that?
puffthomas is offline  
Old 07-07-2005, 04:13 PM   #6 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

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. [table]![NumberFeild] MOD 5 = 0


office politics is offline  
Old 07-07-2005, 04:23 PM   #7 (permalink)
Newb Techie
 
Join Date: Jun 2005
Posts: 7
Send a message via AIM to puffthomas
Default

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.
puffthomas is offline  
Old 07-07-2005, 04:24 PM   #8 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

i aim to please, yw
office politics is offline  
Old 07-12-2005, 02:59 PM   #9 (permalink)
Newb Techie
 
Join Date: Jun 2005
Posts: 7
Send a message via AIM to puffthomas
Default

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

puffthomas is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 11:59 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.