Search results

I tried DMax but get the same #Error result as DLookUp after correcting my Bus# naming to Bus

Renaming my Bus# field solved the Invalid date but now have #Error for my result.

Ok, I have renamed all of my Bus# references to [Bus]. This has gotten rid of my Invalid Date error, but now my final result gives me a #Error in the field box. I have tried several variations of the DLookUp and DMax with the same result. I have also tried After Update in the Bus field box to...

Ahh ok, I'm actually in process taking the advice to correct this now. approx. 15-20 Queries to update. I'll let you know hopefully shortly. I'll edit the SQL's its faster - UPDATE - Gonna take longer than I thought. I'll check back in tomorrow. Thank you all for your advice so far!

I'm going to look into Dmax now and let you know. <Sorry I was having issues replying earlier>

Yes Ive been using this database for 7 years this way and I've learned alot from scratch over the years. There are alot of beginning badd habits in here. But changing to BusNum will not change my results for the Dlookup error. I will sit down once the code is resolved to clean up alot of these...

I received the same invalid date result:

@plog - I say yes because I need the LastEntryTimeStamp result included with the maintenance data for antoher query which analyzes Liquidated Damages LD's which looks at excessive time for repairs between reported issue date "LastEntryTimeStamp" and Repair "Date" which is from this form. This LD...

Ok thank you, I will try to play with your advice. I've been really struggling with this for some time and time is running out on me :) Ok thank you, I will try to play with your advice. I've been really struggling with this for some time and time is running out on me :)

I'm hoping someone can assist with a unique issue I am having trying to come up with a solution to my Form data. I have a Form (CamInputToMaintT Form) which of course adds data to a Table (MaintT). The data from this form evenetually merges data from multiple table queries for multiple end query...