Search results for query: *

Hello there, MajP your solution worked wonderfully!!! I've been looking at my form and need to make a few changes to trap all the potential issues. So now I need to put this code with some others and am having a bit of trouble. In the BeforeUpdate event I call this function so make sure there...

Hello, I can't seem to figure out something that should probably be pretty easy. It just doesn't work, I'm sure its something dumb! I have an unbound text box with a number of fields of the form concatenated in it (I know its strange not my idea). I need to check that in the each new text box...

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 :)

Hello, I had previously asked a question in how to filter records based on date and was able to get it to work. However, it now leaves some groups with only one member, and I don't want to include groups of less than 1. I've tried using count, but can't seem to get it working. The field that...

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...

Hi, Thanks for posting. I hadn't checked back recently since no one seemed to be answering. I worked away and came up with a solution - not quite what you suggested. But the problem is its REALLY slow. It uses two queries (both seem to be slow on their own) and then a UNION query to get the...

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...