Parentheses Problem

Feb 1, 2006

The following query works, I'm just wanting to add a date parameter (below)...When I add the data parameter it seems to ignore that criteria.

I just want to add this:
Event_Date Between [Enter Start Date mm/dd/yyyy] And [Enter End Date mm/dd/yyyy]

WHERE (((tblContacts_Speakers.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_1.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_1.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_2.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_2.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_3.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_3.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_4.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_4.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_5.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_5.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_6.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_6.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_7.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_7.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_8.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_8.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname])) OR (((tblContacts_Speakers_9.Contact_Fname)=[FORMS]![frmFirstLast_Name]![txtFname]) AND ((tblContacts_Speakers_9.Contact_Lname)=[FORMS]![frmFirstLast_Name]![txtLname]));

View Replies

Extract Text Between Parentheses

Sep 12, 2007

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.

Mid([SIDE_DRUG_DESC],InStr(1,[SIDE_DRUG_DESC],"(",1)+1,Len([SIDE_DRUG_DESC])-(InStr(1,[SIDE_DRUG_DESC],"(",1)+1))

View 3 Replies

Oct 29, 2012

I'm trying to use literal parentheses within a text calculation, like: Emergency Medicine ([doctors.doctor name]).

But they just won't show. I've tried to use quotation marks around all literal text, like: "Emergency Medicine ("[doctors.doctor name]")" to no avail.

View 1 Replies

Jun 18, 2014

I am very new to access less than 1 week since i started trying to build an horse racing database, i am trying to link data from 2 different sources via the horses name however one source displays this with the horses country of origin in parenthesis foe example FRANKEL(GB) and the other source displays the name as just FRANKEL, to be honest i haven't yet tried the link but guess it will fail.

I am therefore looking to get rid of the parentheses and their contents from an access table field and create another field without them.

In Excel i use the formula B1:

=TRIM(REPLACE(A1,FIND("(",A1&"("),FIND(")",A1&")")-(FIND("(",A1&"(")-1),"")) and that works fine.

I guessed the solution for Access would be newname:

TRIM(REPLACE([frhorse.NAME],FIND("(",[frhorse.NAME]&"("),FIND(")",[frhorse.NAME]&")")-(FIND("(",[frhorse.NAME]&"(")-1),""))

But this doesn't work as in returns undefined function "FIND" in expression error.

View 7 Replies

View Related

Parentheses Problem

Extract Text Between Parentheses

Text Calculations / Literal Parentheses Won't Show

Removing Parentheses And Its Contents From Access Table Field