Search results

I found the solution. All I had to do was enter MAX in the total line under date that causes it to only show the line with the highest date.

I have two queries. One has an item field, a field for dates (date) and the other has a list of holiday dates (holidates). I have an if statement that compares the date to the holidates and tells it how many days to add to bring it to the next work day if it is a holiday. My problem is that...

I have discovered the reason the fields are disappearing. If any query isn't working for some reason (even if it isn't apparent), any queries even remotely connected to it will not show their fields for selection anywhere. The queries that are not connected to it will still show there fields...

It is very strange, the only place you can see the fields is in the actual queries in any mode. Anywhere else that you try to call the query fields from they just don't show, it looks like all the queries are empty. One minute they were there and then they weren't. It has happened before but...

In Expression Builder and other areas of Access where the fields of a query show, my fields are not showing anymore for any of my queries. Does anyone have a solution for this? Thanks.

I created a function and when I try to use it in my query I am getting the error message Undefined Function in Expression. This is the function: Option Compare Database Option Explicit Function Next_Weekday(DateField As Date) As Date If Next_Weekday((DateField)) = 1 Then...

I resolved my problem by creating a query with only the clientID and the progress note date and then did a MAX for the progress note date. I then created another query which included all the other info from the original progress note query by creating equal joins between the client id and note...

Sorry, I can't post it due to confidentiality reasons. I realize it is difficult to resolve something when you can't see the whole picture. Thanks for trying :)

Sorry, I didn't realize all the fields needed to be grouped. I did so and it produced all the same records, showing the max dates, and there are chinese symbols in the notes field. This query does have three queries joined and there is a subquery.

Hi Adam, This format didn't work for me. It gave me this error: "You tried to execute a query that does not include the specified expression 'query name' as part of an aggregate function. "query name" is the name of one of the queries it pulls from. It works fine when I remove the MAX part...

I need it to return all the different clients only showing the one progress note for each client. How would I incorporate this into the rest of the query. Thanks.

Two of the fields in my query are for Progress Note and Progress Note Date. Each client has several progress notes. How can I have the query show only the Progress Note with the latest date? :confused:

The report opens when you hit the ok button. I also have a command button to cancel the form. I have tried using the close and cancel commands but it prompts for the parameters whichever one I use. Do you have another suggestion of how I can program the cancel button? Thanks. :)

I have a report where you enter the criteria via a form, it works fine, except when you close or cancel the form it continues to prompt for the criteria as if you were running the report without the form. It only prompts for the criteria that hasn't had any data put in it through the form...

I created a delete query and added it to my macro to run it. Works great. Thanks!

Thanks, I will try that tomorrow!

When I import an excel spreadsheet into my Access database it always creates a couple of new blank records. I import this spreadsheet frequently so I would like to set up a macro that will automatically delete any blank records it creates. Can someone tell me specifically how to do this...

Thanks Jon K your solution worked! I wasn't aware you could declare the data type on parameters that easily. You're great!

I did verify that the date is an actual date and not a string and since when I type the dates directly into the criteria it returns the correct records that also tells me that it must be a date. I also tried using > or < and it also returns the incorrect records. I searched the internet and...

In MS Access 97 I have a basic query based on a single table. When I use "Between [Start Date] and [End Date]" as the criteria in a date field it returns incorrect records. It works correctly on date fields that are not calculated but not on the date field that is calculated. If I type in...