Search results

Thanks so much for your quick reply. My problem is a bit different than that. The "real" data actually resides in an ERP system (SAP). I will be receiving a download which I will upload into Access. Once in Access, I will be looking for all sorts of bad data, the upper/lower case issue is...

I need to build a query that will check the name field for Uppercase. Rule is that the name field should be uppercase. We want to find all instances where there is lowercase in the name field. Any suggestions? Thanks...

I have a table called Employees. It has approx. 20 fields and roughly 4000 records. Any of they fields may contain a the phrase "data not available." I need to create a query that picks out all records that have the "no data available" phrase in any of the 20 fields. My first thought was to...

I currently use a module that will open MS outlook from Access. Is there a way to open Lotus Notes from Access and send a Lotus Notes e-mail message? Thanks!

I am looking for a way to calculate weekdays. I have a field that captures the date a case was opened. My requirement is to track the number of weekdays the case is open, so currently I'm simply doing a datediff between the case open date and today's date. Problem is the user doesn't want...

:confused: I have a field called "Office." The data looks like this: STAFF/HR/Finance DIR/OHD/Training etc. I am building a report where all I need to display is the first item in the office string, such as STAFF or DIR. Is there a way for me to tell the report to NOT print anything to...

I have never used Access workgroup security and have a question. Will setting up security and/or a workgroup alter the individual database that I am currently working on, or will it alter the settings on the Access application, which will carry over into all databases, both past and future...

I inherited a database that is the back-end of a web based survey. My task is to help the survey analists extract the data. Their requirement is to have the data come out as one row per survey respondent. However, the developer designed the table to collect the data as follows: Each "answer"...

I have a continuous form that lists action items and their due date. When the user opens the form, I would like the text in the "due date" field to turn red for overdue actoin items. I am stuggling with this and would appreciate any insight. Thanks!

Thanks, it worked! :-)

I need to calculate the median of a group of numbers in a query. Excel does this nicely, but I cannot find a function in Access. Does anyone out there know where I can get my hands on such a function to use in Access? Thanks in advance.

Check this out: http://www.mvps.org/access/strings/str0001.htm

Travis, Thank you so much! The J-date function worked like a charm, and the GMT conversion is amazing! I'm on the East Coast (USA) and when I run the GMT module it tells me that GMT is 5 hours from my current time, which indeed it is. Thank you again for your help. Lynn :-)

Does anyone know of a function that will convert the system time to Greenwich Mean Time (Zulu)? I am also looking for a function to convert the system date to Julian Date. Any suggestions would be greatly appreciated! Lynn