Search results

Not quite... Thank you...we are closer now, but it gives an #Error message for the Null fields, even though it WILL count the fields with data. How can I get around this? I read in the help files that DCount will not count Null fields without a "*", but I do not want to count ALL fields, only...

I am trying to use the following statement to count records: However, when my field [facility] is null, the count comes back as "0", even though there are many fields that have no facility. When this is the case, I want it to count the records for which the [facility] field is null. How can...

That worked! The 1st one did it. Thanks!

It worked! That worked! Thank you! Now, along a related theme, how can I get the date stamp to update whenever ONLY a subform is edited? I have the command there, but it does not seem to work. Currently, the code is: Private Sub Form_BeforeUpdate(Cancel As Integer) Me.RecordUpdated =...

Thanks! Thanks! I will try that! But what do I do if I want to see the field, so that when I enter, I know when it was last updated? If I keep the control, but update the record instead, will that work?

I have a form that has a wizard-generated search box to find a particular record. This particular form also has a field that automatically logs "Now()" when you change records. The problem is that sometimes when you use the search box to locate a particular record, if you make a very minimal...

I posted yesterday about some unnormalized data that I inherited. Thanks to Len & Uncle who responded with solutions. We are STILL :mad: working to clean up that mess & get some usable data. However, we are thinking ahead to the future and how we can do this better next year. My question...

Len, will the Union query work to join fields in the same table? There is only one table, but each question may have, say, 5 fields...one for each of the 5 answers. Uncle. Excel is a good idea, but how can I combine the many fields (above) into one? Is there an easy way to do that? OR, for...

Can anyone help me!!! I have inherited a project that has un-normalized data. The project is a survey, and we need data back ASAP, so I do not have time to restructure the thing. The designer set it up so that each possible answer is a seperate field, about 102 of them. For example, we have...

Thanks!!!!!!! Hmmmmmm. Close I think, although, I think to capture those folks who start or end DURING September too, we need to tweak it like this... ([BegDate] >= #09/01/2004# AND [BegDate] <= #09/30/2004#) (Residents who START their rotation during September) OR ([EndDate] >= #09/01/2004#...

I am working on a database tracking resident & student rotations in a hospital. Most of them rotate even amounts of time...from the 1st of a given month to the last of that month. There are fields in the database for Rotation Start date AND Rotation End Date. The problem is that some of the...

I work in a hospital & I am working on a database to keep track of the monthly comings & goings of our medical students & residents, as well as a lot of demographic data. I am designing the database so that it can be shared by the various clinical departments and the Education department. The...

Thank you!! Thanks for ALL your help anyway. I could not have gotten nearly as far without you! I thought I would add that last note just in case someone with a similar problem was looking for the final solution.

I Figured It Out!!! For anyone who is following this, I FINALLY managed to fix my problem with this code (slightly altered from an attachment posted by Jinky44 posted on 12/30/03 at 01:51 AM) at: http://www.utteraccess.com/forums/showflat.php?Cat=&Number=355743 This was an answer to someone...

Thanks. This is great! I have forwarded it to my friend. Thank you.

It sucks all right! Yes, Even I have noticed some errors. I use both Access 97 and 2000, and it is as if they forget to fix some of the help files when they upgrade. It would be nice if, when you discovered an error, you could fix it on your own machine so you would not have to re-discover...

Would you mind sending a little additional guidance? I hate to keep bugging you, but I am in a bit over my head. I am just learning VBA and I am not quite sure what I am doing. I have been working on this & trying to figure out how to fix it, but I am still getting an error message: I have...

Hmm. Thank you for responding. This is interesting. Why would an Excel command come up under Access help from within Access?

I have a friend (Really!) who has asked me how to calsulate the number of workdays between two dates. I did not know offhand, but a brief review of the Access help files revealed this: I experimented with this myself in queries and reports, and was not able to get it to work. Is anyone...

Anyone have any ideas here? Thanks!