Search results

I need an expression which finds the first space from the right and returns the text (variable length) to the right of it. Ex. AMINOPH, THEOPHY. INJ expression should return INJ

I have an expression below that I am trying to use to extract text from within parentheses in a field, but it is leaving the last ")" on the extracted text. Can anyone help me determine what I need to do to just return the text? Thanks. The length of the field is 100...

Thanks, that worked!

I read the examples in the help, but I'm still don't understand how to go about writing the expression/function. Any help would be appreciated.

I need a query to search each record in a field for an open parenthesis and verify that there is a closing paenthesis. If there is no closing parenthesis, then I need it to return the records not meeting this criteria. I am not very strong in VBA and would appreciate an example function. Thanks

I am using the following code to open multiple workbooks and copy a range of cells into one workbook. It is currently copying B12 to D12 and inserting values into A:C. I want to modify the code to just copy B12 & D12 and insert into columns A & B in new worksheet. I would also like to specify in...

That worked. Thanks.

The below code is giving the attached error after running the first time. The user enters a date range, selects a carrier and client from list boxes, and the query pulls back the data in datasheet view. Option Compare Database Option Explicit Dim db As Database Dim qdf As QueryDef...

I am trying to run the below union query, but it keeps asking for FRGHT_BL!FB_CREAT_DTM as a parameter. I want it to only ask for the Start Date and End Date once. SELECT * FROM qLOC_ID WHERE(((FRGHT_BL!FB_CREAT_DTM) Between [Enter Start Date] And [Enter End Date])) UNION SELECT * FROM...

cascading comboboxes I am creating a database that stores client and carrier rate information. I need to create a form that shows the carrier rate information when a specific client is selected. So when I select the client it pulls a specific list of carriers for that client. I would like to be...

Thanks, that worked.

Is there a way to enter blank fields into a maketable query without using Null, MfstAccsAmt: Null? I can't just use design view to change the field type because the table is deleted everytime the code is run. I have an update query that runs after the maketable query and populates the blank...