var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Is there away in criteria for a query that you can set it so that only the oldest date is pulled? If so can some one tell me how?
Probably depends on what you're trying to achieve. One way would be the TOP predicate:
SELECT TOP 1 ...
ORDER BY DateField
That didn't achieve what I am trying to do.
The query gives depart, name, create date and req number. I only want one record though for a req number and none of the tables have primary keys to them. I didn't design this database just trying to work with what I have.
Does this fit the situation?
Most recent value
Accept that it isn't the most recent date I need. It's the Original date that I need...
So change Max to Min.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors