Recent content by pmonaghan

Sure. FLEmails fields: ID | File | Folder | From | To | cc | Bcc | Attachments | Subject | Body | Sent | Received FLImportantEmails fields: MinOfPriority | From | Subject | Sent

Thanks for replying. I'm afraid I got a bit mixed up with my table names there. Another search I ran in the mean time is below. This has the right query name but still gives the parameter error. The error says: Enter Parameter Value FLImportantEMails.MinOfFile If that helps. FL Queries...

Thanks for looking. I'm currently working with a very large database which contains a lot of duplicates. I had a lot of help in my last thread but I have a few more questions I need to find answers for. The project I am working on is based on email analysis. I have restored five mailboxes...

Ok My queries appear to work as before now. qryImporantEmails: SELECT Min(tblFilePriority.File) AS MinOfFile, kst_tbl.From, kst_tbl.Subject, kst_tbl.Sent FROM kst_tbl INNER JOIN tblFilePriority ON kst_tbl.File=tblFilePriority.File GROUP BY kst_tbl.From, kst_tbl.Subject, kst_tbl.Sent...

1. So I changed the name of [FileName] in my Lookup Table to [File] to avoid confusion 2. When I run my qryImportantEmails the [MinOfFilePriority] fields returns a number instead of the file name. Is this correct? Is this what is confusing the line of the qryDuplicateEmails below? WHERE...

Haha sounds like far too much effort! This still asks for parameter value for qryImportantEmails.MinofFile My qryDuplicateEmails SQL: SELECT kst_tbl.* FROM kst_tbl INNER JOIN qryImportantEmails ON (kst_tbl.From=qryImportantEmails.From) AND (kst_tbl.Subject=qryImportantEmails.Subject) AND...

Also- you're not located anywhere near Surrey are you!?

I think its because I don't have the file field in my qryImportantEmails query... WHERE ((([qryImportantEmails].[MinOfFileName])<>[kst_tbl].[File])); How do I fix this?

So I'm rewriting my second initial query to have another go but its asking me for a parameter value when I try to run the qry. My tblImportantFolders has two fields: [FileName] and [FilePriority] My table is called kst_tbl The SQL for the qry looks like this: SELECT kst_tbl.* FROM kst_tbl...

Ok, I simply can't share this data. By the time I've changed the senstive parts theres nothing left to look at. Theres no point. Just picking up one something you wrote.. I want the duplicate query to treat a record as a duplicate if it has the same sender, subject and sent time (the sent...

Its a little strange.. the From, Subject and Sent fields all match in the duplicates but they haven't been deduped out.. I'm going to scramble the sensitive data on a selection of my data so I can show you an example. I'll also have a look at the Priority Folder query you wrote. Thanks so...

Also, I'm not sure if this makes a difference to the output but the qryImportantEmails qry isn't exactly as we have described above. As you may have suspected, the File field has a file name in it instead of a dataset number as I simplified previously. The files I have are: Personal Folder...

Ok- that runs now, however when I run the delete query I still have duplcates in the table- around 120 to be precise. I assume you are going to ask for the table I am working on at this point.. which I can't really share for confidentiality reasons. Is there anything you can see thats wrong with...

Thanks for this AccessofEvil. I should probably give you the right field names now I am back at the right computer. ID, File, CorrectedFolder, From, To, CC, BCC, Attachment, Subject, Body, Sent, Received The table is called RAT. I changed the fields in the query as my criteria for a...

Not quite... this is 10.