Search results for query: *

Well, the last two suggestions both gave more than one entry per Name. Thanks to the idea of a subquery, I think I've found a solution that will work acceptably: SELECT tblLog.LogID, tblLog.Name, tblLog.Entrydate FROM tblLog WHERE ((([Entrydate] & [Name]) In (SELECT...

Using DISTINCTROW as in this query SELECT distinctrow tblLog.LogID,Max(tblLog.Entrydate) AS MaxOfEntrydate, tblLog.Name FROM tblLog GROUP BY tblLog.LogID, tblLog.Name; returns multiple entries per Name. I need just the one entry per Name. THanks for your ideas - this is about as far as I...

Thanks again, but the last suggestion only returns me ONE record, and not one record for each Name.

How exactly would I use SELECT TOP 1 ???

Thanks, mgolla, but since LogID is the primary key and every value is unique, when I do what you suggested, I don't get just one entry per Name: I get one entry for each different Name and LogID combination. Here is what I believe you were suggesting: SELECT distinct Max(tblLog.Entrydate) AS...

Greetings. I need help with a simple Access 2000 query. Let’s say I have a table that contains log entries for multiple people with the following fields: LogID (primary key) Name EntryDateTime TheLogEntry In this table, there will be multiple entries for multiple people. Let’s assume the...

Thanks for your ideas. Here’s some responses to your responses: We don’t use any FAT partitions in either our workstations or servers, and our test environment (server and a workstation) is the same as the offices that are using the app. The OS on the users PCs is Windows 2000 – same as our...

Greetings. I have an unusual VBA problem within the Access 2000 application that my team and I have created. Let me first explain the app and environment: we have created a multi-user (not client/server) app that is starting to be used in multiple offices, each office having a Windows NT...