Search results

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...

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...

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...

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...

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...

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...

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...

I'm trying to take a name field from a table and split it into two fields -- first and last name -- with a query. Current column: "Doe,John" Need to split in to two columns: Last:"Doe" First:"John" Can someone help me with the expression on how to achieve this? Thanks so much!

I am new to importing an ASCII files into Access and was hoping to get some basic/newbie information from anyone that can help. I am receiving a daily file in ASCII format with no headers. I do have another text file with header information and column start and width information. I am...

Although there are other posts out there about calculating MTD, I'm not able to make any sense of them... they are much more complex than what I'm trying to achieve, so I hope no one minds a new thread... I have a query that needs to count how many days per month transactions were posted. I...

I have a column of data formatted as Date/Time and the value is displayed as HH:MM:SS AM/PM. I am trying to run a query whereby values are between 8 am and 4 pm. Can someone tell me how to write this expression? Here is what I tried and got errors: During Office Hours: IIF([admit...

Is there a trick to why the update query will not update my first row of daya, but all other rows work correctly? I have 12 update queries that update 12 columns on table 1. There are 20 rows per column. Rows 2-20 update perfectly on all 12 columns, but row one on each query does not--all the...

I imported an excel spreadsheet into access but am having issues with a field's data. In excel, it is an alpha numeric field, but imported as text. As a result, I'm getting formatting errors. For example, the value is 804344000 in Excel but is being imported as the scientific value of...

I'm using VBA to transfer a query result to Excel. I'm getting a debug error for the red text. I am a begginer with VBA and am modifying another programmer's code. The only thing I changed with the query string. After I updated the query name/fields, it stopped working. Does anyone know...

Does anyone know how to remove the decimals from this text: 225.00 (this is a text field) I want it to state: 225 (text) Help... :-)

Hi all. I'm using the following to export query results to Excel: DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "QryFinalRawExportTbl_SWD", "P:\SWD\IP\TemplateSWD.xls" Can someone tell me what further is needed to direct it to a specific excel tab? I will be exporting...