Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mickeyziggyk
- Content: Threads
- Order by date
-
Temporal query (all rows starting at the closest date to Jan 1st 08)
Hello All I work with a HR db that has no end dates built into its design. I only have effective dates that represent the start of a change to an employee's profile. I want to see all records/changes about every employee from the date Jan 1st 2008. But some employees have had no changes to...- mickeyziggyk
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
-
Aggregate SQL queries in Access / duplicates that are NOT max
Greetings I think I have an interesting question that has me baffled. It is as so: I have a relation/table that has the following structure: ID1 (auto int pkey) ID (text / char) Empl_recd_no (int) There are duplicate entries within the attribute / column 'ID'. For each duplicate entry there...- mickeyziggyk
- Thread
- Replies: 4
- Forum: Microsoft: Access Queries and JET SQL
