Search results

I'm a flippin idiot lol I think I got it. I had tried to filter out the null values but it wouldn't be null. That Cdate code is going to cause a #error when the pxCreateDateTime is null , I needed to filter out where null on the FIRST query not the 2nd. I'm so sorry for wasting time, I am 99%...

Same problem with that query you just gave.... it gives an error of data mismatch. Once I delete the null record it works. caAssignmentDate is created by another query. The reason being the original date comes across as a string (yyymmdd&"T"&hhmmss.sss&" GMT") based on 24 hour clock. I then...

Unfortunately, sharepoint is slow as hell and doesn't "cache" in that manner in 2007. It was improved in 2010. There are little things here and there you can do to help make it faster. I can't post the link since I don't have enough posts, but google "How to avoid the Top 5 SharePoint...

I wish it was :( I tried that before and just tried it again, same problem. As soon as I delete the null record or if i delete the >10 criteria it works.

When I used DateDiff it said function not assigned... kind of odd. I was able to wrap the Date() - the other date field in CInt to make sure that was seen as a int. It is recognizing the field as numeric (it was before also).... I don't understand lol... it should be working. It works...

I also just tried throwing an extra query in between the table & query 1... I had it exclude the null records. Same problem where I am running into a data type mismatch. I am... stuck lol. I don't get why I can't add a criteria of >10... if I pull the query with no criteria, access sees the...

I don't believe NZ will work mostly because the result is #ERROR and not null. I had tried... NZ(CDate(Mid([tbl_NF_Pinless]![pxCreateDateTime],5,2) & "-" & Mid([tbl_NF_Pinless]![pxCreateDateTime],7,2) & "-" & Left([tbl_NF_Pinless]![pxCreateDateTime],4)),0) But that just results in #ERROR. I...

I am trying to avoid a data mismatch for my query. The portion of the query (query2) causing the problem is: SELECT Date()-[caAssignmentDate] AS AsgnAge FROM Query1 WHERE (((Date()-[caAssignmentDate])>10)); If I remove the WHERE portion, it works fine. If I remove the null records from the...

Well i found a big issue that my xl.workbook open code causes my excel to go crazy and it makes excel open with a blank window. No idea why but the only fix is to delete my windows profile. So i need to remove all that code. So going back, is there any way to import excel files with a static...

Hello, I have 4 excel files I run /w VBA to import. The issue is 2 of the files have their worksheet name change every day by the system I am exporting them from. My original macro was very simple... DoCmd.RunSavedImportExport "123" DoCmd.RunSavedImportExport "456" DoCmd.RunSavedImportExport...