Search results for query: *

...would like to remove this sample from the box?", vbYesNo, "Continue") If LResponse = vbYes Then DoCmd.SetWarnings False DoCmd.RunSQL "Delete * FROM tbl_newentryexample_Normalized WHERE [Sample_ID] = '" & Me.A1.OldValue & "'" DoCmd.SetWarnings False Else Me.A1.Value = Me.A1.OldValue...

...check that in the each new text box, on the AfterUpdate there aren't duplicates of any of these fields. So right now my code is: If Me.A1 Like "*" & Me.[txtConcatenateFields]&"*" Then MsgBox ("You've already entered this sample") Endif Believe me I know that this is a bit odd, but I...

That worked perfectly - much appreciated! Thanks

Hello, I'm having trouble figuring this one out. I have a text file, that will always have a tab before the first field header which shifts everything over when I import the file to Access. I'm looking for a way to get rid of this, but I'm not sure how to refer specifically to this tab only...

Everything works perfectly! Thank you so much for all the help, it is so very very much appreciated, I've been going in circles on this one for awhile. :)

I still want to observe all the same restrictions as before with respect to single's in an SM24_No group. Yes if some, but not all members have been contacted I'd like to see the whole group (contacted and not) so I know who's in the group. The only time I don't need to see a group is if...

Hello :) The most recent code you posted works to eliminate the case of Jarod and Jerry, since you added a WHERE outside of the second select statement....so all is well. But in playing with the code I've realized I have one more issue I didn't think of in planning this out :( This query is...

Thank you so much for the code. This is helping with eliminating single records, however within the groups (by SM24_No) records that have RECDATE >2years will appear. If everyone in the group has a RECDATE >2years ago the entire group won't show (which is what I want) but within a group some...

I'm sorry but I tried using the code again, and I must have missed something because it doesn't seem to work as I originally thought. Its still giving me single records for groups of SM24_No not sure why since to me the code looks right. Any suggestions would be welcome. Thanks so much

Works wonderfully! Thank you so much for the help, I had tried something similar but I can see where I went wrong now. So very much appreciated :)

...ENTRYTABLE.Strain, ENTRYTABLE.MIRU_24, ENTRYTABLE.SM24Date; The output (minus some fields) looks something like this. *The last group SM24-4 is what I would like to eliminate. SM24_No RECDATE FirstName Surname Key SM24-2 2009-01-03 Bob Smith...

Ok I'll work on the rest, and see where I can get. The other thing I noticed is that groups of 1 appear, but I would only like to show groups with more than one person. I thought that putting SM24_No>1 under HAVING would take care of this but it doesn't seem to. I think I need a COUNT>1 but...

Yes I just realized this and put the other fields I need to see back in. Still not quite the right result - perhaps I've done something wrong. The output it is giving me is individuals that have a RECDATE within 2 years, however I need to see the individuals that have a RECDATE >2years if they...

Ok so I tried this and the output it gave was the individual in each group that had the most recent RECDATE, which isn't quite what I need to get to. I'm lost on this one, I just can't seem to wrap my head around it.

The query is based on an Entrytable, which contains about 50 fields. About a dozen are included in the report, but the relevant ones for filtering the data are the group which is a field called SM24_No and this is a text field, and the date added is a field called RECDATE - which is a date...

I'm having trouble figuring out something I think should be fairly basic. I have a form, from which there are a few parameters that can be chosen which will open different reports. The reports are based on queries which is where I'm having a problem. I have data that has previously been...

Thanks for the code, it seems to be running faster then the code I was using. I'm just not sure how exactly to implement it in the form. Since the Append queries have to be updated first and then the final query to get the newest result and I don't have experience with Append queries so I'm not...

...HAVING (((ENTRYTABLE.Surname) In (SELECT [Surname] FROM [Entrytable] As Tmp GROUP BY [Surname],left([FirstName],2),[DOB] HAVING Count(*)>1 And left([FirstName],2) = left([Entrytable].[FirstName],2) And [DOB] = [Entrytable].[DOB])) AND ((Count(ENTRYTABLE.TBR_No))<>Count("No_Patients:Key")))...

Hello, I'm having trouble with a select query. I'll explain what I would like to see and maybe someone can suggest how I get there. I have a database that has duplicate patients, and unfortunately the quality of data is not always great due to the source - nothing I can really do about it...

As mentioned in the post we don't always get this information. The patients don't always have one (refugees, immigrants) are homeless and don't provide or have one. Or for some reason this information was not passed along to us. Unfortunately we don't have anything completely unique to the...