Quote:
Originally Posted by Moonliner
#2 Would be: Select * from Your.db where mid(datefield,5,2)='04'
|
I found a better to resolve for #2: I had the client provide me with records already suppressed to the month of April
Quote:
Originally Posted by Moonliner
When all you have is a hammer, every job looks like a nail.
-- Unknown.
Seriously dude, import this **** into a database.
|
Well, yes, this might be a better tool. But then I would have to purchase and learn said new tool. If 95% of what I need to transport can be covered by a pickup truck, I am not going to buy a semi-truck and get a class A license for that other 5% - I'll just make a couple of extra trips as needed.
Besides, I got to learn how to make a lookup table today!