Search results

All records have the following structure. (/SBMA/ArtStorage105_temp,14-Oct-23 8:45 AM PDT,68.5) Sensor Zone, Date of Reading, Value of Reading Sensor Zone has two entries per reading time....TEMP and RH. Readings for each are taken every 15 minutes. I don't care about the PDT....as all of my...

Source field is text Destinantion field is date I get a type mismatch

such as... cdate(replace("[FieldName]"," PDT","",1))

Time Zone is not important as I am only concerned with one facility.....if I have multiple facilities in multiple countries.....maybe.

I presume then that I could replace the "date" with the field name?

After searching through the treads on this topic, I needed help finding a post that addressed this question clearly. I receive a .cvs file every morning from my HVAC system controller that gives me time-specific readings of all the mechanical equipment in the building. There are generally 6,000...

I am a corporate user of Access and would like to get it to help me keep track of environmental conditions in a museum. My professional background is in architecture, with some experience as a beta tester for Microsoft in the 1990s and an early adopter of technology. I have been away from...