Quote:
Originally Posted by Kevy Baby
1. Get a list of all entries in a column (in other words, if I have 50,000 records and column H has a listing by state, I want a list of the states covered in this list [obviously not all 50 states]).
2. Create a list of records with birthdays in a certain month (in this case, April).
[list=1][*]Convert the Birth Date column to text. Note that this data came to me with the date already in a text format listed at YYYYMMDD (no dashes or slashes).
|
When all you have is a hammer, every job looks like a nail.
-- Unknown.
Seriously dude, import this **** into a database.
#1 Then becomes: Select DISTINCT State from Your.bd
#2 Would be: Select * from Your.db where mid(datefield,5,2)='04'