Search results

Thanks all, who have offered answers! The field that I'm trying to audit is a freeform field, which is one of the reasons why I need to try and make the audit as easy as possible. When I posted my question, the spaces I had entered for my example disappeared, eg the spaces after the "1STA" in...

Hello all - I'm sure this is simple but my googling yielded nothing. I'm trying to create an update query on a field that is supposed to have a specific naming convention and can't figure out how to phrase it in the query. The data in the field should be '1STA xx/xx/xx'. The xs in the data...

I'm working on a utilization database and pulling Excel data from Cognos 8. I use Access formulas to separate hours and minutes because I want to use time (.30, .45 (minutes)) instead of quarterly increments (.25, .50). I've successfully segregated hours, because I also have to turn days into...

Hi all, I use Cognos to pull raw data from Oracle. I take this data and put it into Access 2010 tables to then run queries. Because the people creating the data in Oracle are often slow, I run back data to catch missed information, typically two months. For October, for example, I'll run...

Thank you so much, that worked perfectly!!!!

Simple division, I thought! I'm dividing a Sum of hours by Pay Periods to determine the average of missing hours for year-to-date. Most of the division works perfectly, and some doesn't and appears to be related to values of 1 or less than one. The formula: [Sum]/[Pay Periods] Sum relates...

This is crazy, but I can't get this to work! I am re-using a database to create new reporting. It was a technician utilization database that I am reworking to show weekend days worked. I changed the date format to Long Date to show the day, then started a query. The query is looking for...

Hi! I'm trying to calculate response time in days and hours using the work ticket create date/time field and the labor start date/time field. I'm not good with sql, so I'm looking for an expression i can type into the query. I'm currently using Access 2003. I have no problem with the...

I'm trying to modify an Access db created by a former employee. He used to type in the mthly hours worked to calculate monthly utilization. The rest of the data for utilization was imported from an Excel file, and Hrs Worked is a column added to that table. I want to add that Hrs Worked value...