Search results

Thanks for your input Paul. I actually found it! Here it is in case you ever need it. Works so well... CDate(Format([admit time],"@@\:@@"))

Let me clarify by example above. I indicate "date" in error. There is no "date" data. The raw text value is for example: 900 and needs to show as 9:00 AM no date is involved.

I am going absolutely awol trying to find the formula... I had it in a query, but the db corrupted before I saved the query (Access 2010--no surprise)... I am trying to convert a text field to a time value. I had used something like the following and it worked great! Now I can't recall how...

OMG. I am laughing out loud over here. Thank you--I had no idea!

Hi all, I have a date/time field that contains the following: Admit_Date_time: 4/29/2012 12:00:00 AM I am splitting into two fields--one for date and one for time using: FieldA_Date: Left([admit_date_time],InStrRev([admit_date_time],"")-11) FieldA_Time: ADMIT_TIME...

Hi all, I upgraded from Access 2003 to 2010 (ugh!) and now am experiencing several issues from the conversion. I won't plague you with all of them, except this one... Here is my previous VB: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QryABC"...

I'm using two fields from the same table, FieldCount and FieldID. If [FieldCount]=2, I want to count the number of IDs found in [FieldID]. And in another column, if [FieldCount]>2, I want to count the number of those IDs found in [FieldID]. Here is the best way I can think of to explain it...

I tried the expression above, but unfortunately, it excludes all records. I also studied and tried the Nz function but that is not working either. I believe what I earlier referred to as NULL should have been EMPTY. What would you all suggest for that? I tried: <>Nz("Admit-Inpatient") or...

My query is excluding null values in error. Can someone assist me in where my code error is? I have one table I'm querying from and using two fields to filter. Here is the statement that is excluding the two discharge disposition types, but is also excluding all null values: WHERE...

Yes, I tried that but there is an error message that deletes them all from the table. I also need the values available on the table in phone number format for a different report.

Can someone help me remove the phone number formatting on a field? It's a text field that appears as (@@@) @@@-@@@@. I'd like it to appear and just a straight 10 digits with no formatting. Seems simple enough but my efforts are not working. I've tried: Format([phone],"@@@@@@@@@@")...

I was hoping someone may be able to edit my import VBA below. I receive a text file daily with no headers, but the headers have been built into a spec that I manually apply when importing to a table in Access 2003. I'm trying to create a command for importing the file, but it imports...

Thank you both so much!

I'm trying to separate first and last name in a column into two columns. Seems like there should be a simple query expression for this. Does anyone know what that would be? The field is currently formatted as: Doe, John (one column) Need "Doe" in column 1 and "John" in column 2. Thank...

Please disregard. I had a period in my file name and it thought the text after the period was a new file type. lol

I'm trying to import a .csv file into my existing MS Access 2003 db. When I use the import wizard and select the file from its location, I'm getting the error message: "Microsoft Jet database engine could not find the object (file path). Make sure the object exists and that you spell its...

Top 5 docs based on number of visits.

I would if there were only 5 doctors per hospital, but there are hundreds. I'm looking limit the result to the top 5 docs per hospital.

I have a table that counts the number of hospital visits by hospital and doctor. Since there are hundreds of doctors per hospital, I'd like to limit the return of doctors to the top 5 based on descending highest number of visits. It would look like: Hospital 1 Provider 1 500 visits...

I am getting an error on the following highlighted portion of my code "You can't assign a value to this object". Does anyone know what is wrong? I'm new to combo boxes and calendars. Got this VBA from a Google item... Thanks so much! Private Sub cboAdmitDate1_MouseDown(Button As Integer...