Access/Excel HELP

Vivrantism · 09-12-2007, 10:58 PM

Say I have a cell, and I want to run a query and find totals and such but my some of the cells are duplicate. Is there a formula to exclude duplicate records?

Does anyone know? HELP!!!!

FekNr · 09-12-2007, 10:59 PM

You want Nr to do yor work while you surf net?

Vivrantism · 09-12-2007, 11:02 PM

Anyone with valuable input?

**Ardeur** · 09-12-2007, 11:02 PM

only dorks and nerds know that stuff..

Vivrantism · 09-12-2007, 11:04 PM

Arrrrrrrrrghhhh!!!

Where's Anygma? MightyMike? Dibia? TBP?

Google ain't helping.

KabiYesi · 09-12-2007, 11:05 PM

Filter the dupes of your record; then do your sum.

(select the column- Data - Filter - Autofilter. Select records from drop-down box.)

bettybogus · 09-17-2007, 02:09 AM

use an sql statement.. i believe you can run sql queries on access..

**RUKUS** · 09-17-2007, 03:45 AM

depends on if you're using access or excel...

If you're trying to get rid of duplicates its pretty easy in access to use a sql statement or if you're using the GUI.

If you're using the GUI just change the properties to Unique values (Yes).
If you're using a SQL statement then you can just add a "DISTINCT" right after your SELECT statement.

I dunno if that helps, but holla if you have access/sql/vba/vb questions

Anygma · 09-17-2007, 04:16 AM

Quote:

Originally Posted by RUKUS

depends on if you're using access or excel...

If you're trying to get rid of duplicates its pretty easy in access to use a sql statement or if you're using the GUI.

If you're using the GUI just change the properties to Unique values (Yes).
If you're using a SQL statement then you can just add a "DISTINCT" right after your SELECT statement.

I dunno if that helps, but holla if you have access/sql/vba/vb questions

Wow!...Ruk knows SQL!

...i guess your competitions are getting DELETED!

09-12-2007, 10:58 PM	#1 (permalink)
Vivrantism Wild Card Join Date: Jun 2002 Location: at the bottom of a shoe Posts: 14,042 Points: 395,161,012.75 Bank: 1,926,505,805.74 Total Points: 2,321,666,818.49 Donate Rep Power: 21474885	Access/Excel HELP Say I have a cell, and I want to run a query and find totals and such but my some of the cells are duplicate. Is there a formula to exclude duplicate records? Does anyone know? HELP!!!! __________________ Check out: www.nighttofly.com.

09-12-2007, 10:59 PM	#2 (permalink)
FekNr Crazy Bitch Join Date: Jun 2005 Location: Awaiting Xemu's Orders Posts: 6,721 Points: 300.00 Bank: 154,068,370,988.54 Total Points: 154,068,371,288.54 Donate Rep Power: 21367489	You want Nr to do yor work while you surf net? __________________ "Misled I bled till the poison was gone. And out of the darkness arrived the sweet dawn."

09-12-2007, 11:02 PM	#3 (permalink)
Vivrantism Wild Card Join Date: Jun 2002 Location: at the bottom of a shoe Posts: 14,042 Points: 395,161,012.75 Bank: 1,926,505,805.74 Total Points: 2,321,666,818.49 Donate Rep Power: 21474885	Anyone with valuable input? __________________ Check out: www.nighttofly.com.

09-12-2007, 11:04 PM	#5 (permalink)
Vivrantism Wild Card Join Date: Jun 2002 Location: at the bottom of a shoe Posts: 14,042 Points: 395,161,012.75 Bank: 1,926,505,805.74 Total Points: 2,321,666,818.49 Donate Rep Power: 21474885	Arrrrrrrrrghhhh!!! Where's Anygma? MightyMike? Dibia? TBP? Google ain't helping. __________________ Check out: www.nighttofly.com.

09-17-2007, 02:09 AM	#7 (permalink)
bettybogus Mami Wata Join Date: May 2003 Location: Under the sea Posts: 17,591 Points: 77,006.55 Bank: 1,902,669.48 Total Points: 1,979,676.03 Donate Rep Power: 3212561	use an sql statement.. i believe you can run sql queries on access.. __________________ Bonita Applebum..y'know..like a hip hop song.. Like a perfect verse, over a dope beat.. ~~~~~~~ Jesus take the wheel..

09-12-2007, 11:05 PM	#6 (permalink)
KabiYesi Registered User Join Date: Aug 2004 Location: PLAYAHATAS CLUB Posts: 576 Points: 1,200.00 Bank: 5,494.68 Total Points: 6,694.68 Donate Rep Power: 549602	Filter the dupes of your record; then do your sum. (select the column- Data - Filter - Autofilter. Select records from drop-down box.)

09-17-2007, 03:45 AM	#8 (permalink)
RUKUS Elder Join Date: Mar 2002 Location: Houston, Tx Posts: 2,817 Points: 51,082.95 Bank: 15,661.93 Total Points: 66,744.88 Donate Rep Power: 134929	depends on if you're using access or excel... If you're trying to get rid of duplicates its pretty easy in access to use a sql statement or if you're using the GUI. If you're using the GUI just change the properties to Unique values (Yes). If you're using a SQL statement then you can just add a "DISTINCT" right after your SELECT statement. I dunno if that helps, but holla if you have access/sql/vba/vb questions __________________ JOCK MY FRESH http://www.rukuslive.blogspot.com COP THE DIGITAL VERSION OF "CAN'T FORGET" NOW http://www.cdbaby.com/rukuslive2 RUKUS' WEBSITE http://www.rukuslive.com RUKUS on MYSPACE http://www.myspace.com/rukuslive THE JOHN MAYER PROJECT http://www.myspace.com/thejohnmayerproject CHECK OUT SOME LIVE VIDS OF RUKUS FOLLOW ME ON TWITTER http://www.twitter.com/rukuslive

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode