Search results

Hi Ranman it took a minute for me to understand what you meant but I did it and it worked perfectly. Thank you VERY much

wait..Is the other table that you are referring to the original RESULTS table?

ohhh I see where you might have misunderstood. The "RESULT" column in my example doesnt actually exist. I added that so that everyone could see what my desired outcome is.

Thanks Ranman But I am a bit confused. I only have one table.

Hi all I created a query in access that retrieving data that has the same data in one field but I also want to eliminate data where the data is the same in another field. I have added two attachments and I will explain them both. Excel Example: This is the data in the table that I am using...

Thanks Pbaldy Unfortunately I cannot attach the db as it is HIPPA protected data.

Hi Pbaldy Yes this is for Access..because the file is so big (375,000 rows and 137 columns), I created a link in Access to the excel table because its too big to load. I then made a local copy of the table and used the formula while querying the copied local table. The query starts as if its...

Thanks again Pbaldy Unfortunately this is not working for me. I keep getting a message that the formulas-excel is not working and to switch to fix, but once I do that the whole program locks up and I have to cntrl+alt+del to close it down. I will have to find another way to accomplish what I...

ahh...yes Memno IS text. I toally forgot that. I would need delimiters on that as well. I looked at the site that you posted and I see the delimiters for the date but it looks like I just need the dbl qoutes for the MEMNO which I already have.

Thanks Pbaldy I went to the suggested site and applied the logic I thought was appropriate and still get the #Error. I used: DCount("*","RESULTS1","MEMNO = " & [MEMNO] & " AND BEGDATE <= #" & [BEGDATE] & "#"). What am I doing wrong?

Hi pbaldy I was referred to this thread by someone and this seems to be exactly what I am looking for. I substituted the particulars in Sadist's original post and though it seems like it wants to work, I keep getting #Error. I used the following formula: DATE COUNT...