Search results for query: *

I've also encountered the same problem when using Access 97. I researched it and could find no answer. As the old parrish priest said when asked questions to which there were no clear answers "It's a Mystery

Hello, It does what you say it does. I agree but I need only to extract the unique values of group id. For example if group Id 5 appears twice I need to see the 5 once. At any rate, I fiqured out a solution using a temp table that hold only unique occurances of group ids that are displayed in...

Hello again, Basically I need to extract the groups ids of dataset tthat have duplicates in them. The problem is that the query execution is running very slow. Now what is the exact purpose of the following section of code ORDER BY 1,2,3,4,5,6,7,8,9,10 Is it used to set the order of columns...

Hi thanks, But your solution isn't what I was looking for. Thanks anyway. Juan

Unfortunately, the users are using Access 97

Hello, I tried it but I'm getting a syntax error in the second select clause,

Hello everyone, I've created a query that finds duplicate records. It works fine and it is shown below qryFindDuplicates SELECT DISTINCTROW tblCurrentOptical.Group, tblCurrentOptical.Location, tblCurrentOptical.[Drawer #], tblCurrentOptical.Date, tblCurrentOptical.[Type of Payment]...

Hi, I've already tried that however, it looks like I found the solution For intRowCount = 1 To intTotalRows If (Cells(intRowCount, 10).Value = "Duplicate") Then If Cells(intRowCount + 1, 10).Value = "Ok" Then x = x + 1 Cells(intRowCount + 1...

Hello everyone, I need to identify the last row of each duplicate set that exists in a spreadsheet. The other duplicates of the set will be sent to a worksheet called Duplicate while the last duplicate of the set is retained. However, the use wants to be able to identify which rows in the...

Hello, I had the some problem and I executed the following make table query SELECT DISTINCT * INTO temTable FROM tblImportedBrinks tblImportedBrinks is the table with duplicate rows and I populated the temp table with only unique rows. I then deleted all the records from tblImportedBrinks...

Hello, Thanks for the info. It worked perfectly. In fact, I did try to use the same approach earlier but was unsuccesful. As I implemented your solution I noted that the subforms were not properly named and had taken their name from the underlying table or query. I should have caught that...

Hello everyone, Here is the situation. I've created two subforms that are based on the same underlying table - tblUnmatchedBrinks. I've also created two other subforms based on the same underlying table, in this case tblUnmatched Cadence. Now lets take the first two subform first - the ones...

Thanks to everyone for their help.

You know I was just thinking. Why not keep it in Access. I could create two subform for each of the unmatched table and have each one display in datasheet view. Now the fields will all be visible at the same time - I could create a view details function that would display a subform form in...

Thanks for your response. Actually, I should have gone into more detail. These excel sheets are popuplated by an access application that I created. This application compares two tables - tblCadence, tblBrinks. Each table has several fields that correspond to fields in the other table, though...

Hello everyone, Here's the setup. Users in my department have to reconcile the currency amounts in two different worksheets. In order to do this, they start Excel, then open both Excel files. They then arrange each worksheet, one above the other via Windows -> Arrange -> Horizontal. They...

Hello, I'm currently using Access 97, which I should have mentioned. The table needs to be exported to another database where it will be scanned. Linking doesn't work because the source databases are secured and part of workgroups. When the linked table is exported, the permission structure...

Hello, I'm currently using a split database and I want to be able to permit a user to export a table from the backend to another database via a command button on the front end. When I execute the following code from the front end only the link to the table is exported. I want to be able to...

Thanks dhookom, Your suggestion worked fine. Thank you also RoyVidar. I do have a question about the code solution although I decided to go with the former suggestion. I put the code into the location footer and then put Me.Total_Amount = dblDailyTotal in the date footer I kept getting the...

Hello, I need to create a report where in addition to daily grandtotals, I have to output daily grand totals for all locations that are "Health Connect". When running the report, I find that while my daily grandtotals for the entire day are correct, my daily Health Connect grandtotals are...