Search results

Hello, I'm having a small problem converting a select query I wrote into an update query. Below is my original select statement: SELECT Mid([address3],1,InStrRev([address3]," ")-4) AS CITYx, Mid([address3],InStrRev([address3]," ")-2,2) AS STATEx, Mid([address3],InStrRev([address3]," ")+1,10)...

Alright, I really appreciate the insight...learning something new everyday!!!!:)

Thanks Craig I will try what you're suggesting. I was able to get the following to work SELECT address1 FROM Booktable WHERE (Left([address1],1) Like "[0-9]"); Thanks again!!!!!!!!!!

Ok I appreciate the insight Bob, and yes I've never used the case statement before. I was told by a co-worker that it might be a better solution that using "iif" but I'm finding that an "iif statment" suits my purpose better. Thanks

Yea I was able to do it with an Iif statement....I've never used an case statement and I was told to try it out. Thanks Pbaldy!!!!!

Ok, Thanks for the input Craig....I'm thinking that I'll just stick with an Iif statement to solve my issue.:D

Hi I'm new to query writing and I'm needing help with a query that will search a field that either contains a name or an address and only return fields with addresses. Select address1 From Booktable, Where (Left([address1],1) = Like "[A-Z]" Thanks in advance for any help!:D

Hello, I'm attempting to use a case statement in order to select fields from a column that have names and addresses mixed. I'm wanting to select only the fields that contain names. For example some fields start with an address of "1998 Sky Rd" or PO BOX, or Suite at the beginning of the field...

Hello, I'm writing a query that will append to a table and also convert it dbase IV. The problem that I'm having is controlling the actual field width size when the new table is created as dbase IV for foxpro. It creates every field width size as 256 and I'd like to know to how controll the...

Thanks Keith for your help....I got it to work, I just needed to modify the mid function.:D

I used the above statement and it ran, but the results where incorrect. For example if date last stmt = string "13107" the result the above query gives is "1/10/07" and if the date last stmt = string "122906" the result is correctly displayed as "12/29/06" Any suggestions?????????:confused:

Hello, I'm having a problem writing a query with nested iif's. This query is suppose to manipulate a text field that with #'s. Each field is either 5 or 6 characters containing a date such as "20607" or "10607" which is in the mm,dd,yy format. Can you have a nested iif statement such as below...

I'm examining a previously written query and I'm trying to figure out exactly what the minus sign does when placed before the Instr function. An example of a query that successfully flips a name field is below and includes the -instr function. I've also included another query below this one that...

I appreciate you guys helping!!!!

KeithG, I tried the above and received syntax error missing operator in query expression...

Hello, I am trying to write a query that will search a field for a string until it discovers a comma. If there isn't a comma I want the field left as is. If there is a comma I want it to grab all strings before the comma and then take the string after the comma and flip the arrangement to...

I appreciate your quick reply Pat. I should have been more detailed. My dates are not real date/time data. I have numerous records with various dates from 2004 -2007 and all are in the format MM/DD/YYYY in which I need a query that will change them all to this format MM/DD/YY

Can some help me with a query in access 2003 that looks at dates in this format example: 10/22/2007 and changes them to 10/22/07. Thanks a million in advance!!!!

My mistake on the poll!!!!!!! :D

Hello I'm having trouble getting my nested Iif statement to run. Can anyone help??? I've attached a screen shot of the syntax error that I'm receiving. The example code below needs tweaking. Update [Goodrec-copy3] set [Goodrec-copy3].shortname = Iif (Not...