Recent content by WeebleSue

Okay, well, I kinda solved it myself. I created a new table from the questionable query, so now my "good" date is indeed a column in a table. Now all my filtering works just fine. seems like a bug to me.... one would think that a value in a column of a query would act the same way as a...

Okay, the plot thickens! I have other tables where the date that I'm using to compare, and if the date is a column in a table, I use the same exact critieria using the same exact variables, and the data filters perfectly fine. The data in this questionable query is defined IN the query. It is...

SpikePL, no, there is no = in the Criteria line. That was just to explain that what followed was what i put in the critieria section. The FinalDate is assembled using DateSerial(year, month, date) {and no, those are NOT my real column names}. Is DateSerial not an official "date" result? And...

(I have searched this forum and found other answers to the error message i'm getting, but none of the other users' issues seem to be similar to mine) I retrieve data from a text file that has date/time information in text form. I use a query to grab the revelant data from the text field...

I was able to get it to work using the new Access feature TempVars. They work like a charm!!

Got it. Thank you!

Thanks for the post. Your first [Code] section contained only 2 lines of comments..... but it looks like you posted the entire function below that, so I suppose it doesn't matter. If I use regular Access fields defined as Dates, then I have to store them somewhere like in a Table and I was...

I am using Access 2010, and trying out the Navigation Form feature. I have a form under a tab where I have created two MS Date/Time Selector ActiveX controls. I have the default value set as Today. One is a Start Date and one is an End Date. Once the user has made their selections, I want...

Dang, and I thought I found a bug!! I still think that MS could do a better job when creating their own queries (a'la using the Wizard) - you would think that if i am using dates, trying to sort or group by dates, that their own wizard would know that i want the results in date format as well...

I have entries in my table that occur several times per day. I have created a new Query that Groups By the date field. I want to show only the maximum number that occurs of the entries for that day. But what I have found in the results is that the Grouped By field sorts wrong! It sorts 1/1 1/10...