Search results

I know how to group using the Subtotals and that works for the ID#, but not the date. I don't know VBA. If anyone can help further, it would be appreciated. Thanks.

I have a list of attendance information for a school that I want to group by student and attendance date, and then check to see if there are consecutive periods on the same date for that same student and count them if they exist. Here is sample data: A B C D 1...

Thanks, I tried both of those and still doesn't work. I get this error: "The record source 'SELECT [Tool] FROM tblTools WHERE [ToolID]=1' specified on this form or report does not exist." I tried changing ToolID to ModuleID and same error.

I have been trying to get this to work for days, have tried different examples from this forum and elsewhere and don't know what I am doing wrong. I have one combo box for Module and another for Tool. I want the Tool combo box to only list the Tools for the Module selected in the first combo...

I tried using the first example: iif([StipDate]>iif([Vacate]>[LeaseSigned],[Vacate],[LeaseSigned]),[StipDate],iif([Vacate]>[LeaseSigned],[Vacate])) and I get an error about invalid syntax. I have never used a VBA function in a query. How do you do that? I also don't understand the function...

I need to compare THREE dates. I work in the housing industry and the dates represent different steps in a move out process. For example: Vacate Date, Lease Signed Date and Stipulation Date. Yes, sometimes there may be a null value in one or more of these three date fields. Thanks!

In the example I gave I specified that it was SIMPLIFIED. Without getting into enormous detail, trust me to say that my table is fine. The dates are not related to each other in the way you are thinking.

I have a table that has multiple date fields. I need to compare three of the date fields and return the most recent date. Here is a simplified example of my Main table (tblMain): LName FName Date1 Date2 Date3 How can I find the most recent date between Date1, Date2 and Date3? I will also...

Thank you for the explanation! It makes sense now.

I just went into the References in the database that's not working and checked "Microsoft Outlook 12.0 Object Library" and now it works. I don't understand how the code could work in one and not the other on the same PC, but now it works so I'm good. :-)

I'm running it on the same computer.

I created a test database to test sending email from Access. Everything works great on my test database on C:. When I copy the form/code/query to the database on our network I get this error: "The expression On Click you entered as the event property setting produced the following error...

No, when there are duplicate CN numbers I only want to count that as one record. Thanks again!

I believe it have it working correctly, but I had to do it backwards from your suggestion. I needed to use SELECT DISTINCT in the first query and then in the second query count. If I did the count first it counted the duplcates. Here is what I ended up with: Query One: SELECT DISTINCT...

Thanks. I've tried to break it out before into 2 queries, but it did not work. I will try again following your suggestion and will keep you posted.

So then I'm back where I started.

When I add "SELECT DISTINCTROW tblCalls.CN, " to the front of the query it doesn't work. Instead of finding distinct tblCalls.CN, it groups them so I have a list of the same address many many times instead of it giving me a count of the address. Here is what that query looks like in total...

I have the query below that I need to change to remove duplicates in a field "tblCalls.CN". I have done this in other queries in this same database adding "SELECT DISTINCT tblCalls.CN," to the front of the query statement but that does not work with this query. This query is different in that...

Nicely done! Thank you SO very much!

Yes, here is a sample. I have removed all unneeded items. From the Main Menu, click on "Quick Data Entry." At the Quick Data Entry menu choose the "Dunedin" button to see what happens when there are related records. Choose the "Mt. Airy" button to see what currently happens when there are no...