Search results for query: *

thanks gmmastros i understand now, i guess my real confusion was the -1 next to the charindex function, i was putting ,-1 which would have been the interger_expression for the LEFT function which is not what i wanted. the charindex will find the position of my criteria lets say 5, which will be...

thanks markros I was putting ,-2 that works perfect thanks for the help.

Thanks for the positive feedback... that's what i've been trying but since i am lacking understanding, hence the question in the first place, i'm still having trouble because in the left function there is a interger_expression which depicts how man charaters will be returned, so that's not it...

Thanks markros thats working but for the filed that returns theinfo before 'A-' it is leaving the A in the value so i have: abc A-123 and its returning: abc A how can i only return the info up to the A, not inculding it? Thanks

Hi all, I have a statement (that dhookom helped me with) in a query that i use in access that i need to use in SQL the statement is: Mid([Unnamed Field], Instr([Unnamed Field],"A-")+2) i get an error that says Instr() is not a defined function, can someone help me rewrite this so that i can...

Thanks actually the table I listed above is the desired result you see I need to list all of the leases and tracts but size only once so right now it looks like lease. Tract. Size 1. 1. 5 2. 1. 5 3. 1. 5 4. 2. 7 5. 2...

Hi all, so i am building a query to show all of the leases in all of the tracts that are set up in my db, being that there are many leases in each tract. however the desired output would be each lease record listed with the tract name repeating however many times it has to. that part is easy...

ok i'll try, i was thinking of just rebuilding the form if there wasn't anything obvious ya'll could point me too. Thanks!

Thanks Kjv1611, i am linked directly to the tables and there are more than one record for this recordset. this is a subform i'm talking about so there is a record for the master form and corresponding records for the subform, all being derived from the SQL linked tables(seperate ones that are...

Hi all, I have an access front end link to SQL tables. on a particular form, when i update information on a subform it takes it fine, but after when i try to navigate to the next record or select another record from a combo box, i get an ODBC call failed message and the data in the subform...

ouch dhookom, I was just being funny about being confused on how to combine the functions, which i tried before i asked. So we use the Instr to find a point in the string, mine being A-, and then with Mid and +2 it returns the next two values? i think i understand now. Neverless, this worked...

awe come on dhookom, you're my fav on here and i know that you know that i can't put that together... lol could you by any chance provide the combined code to extrat the "74" out of "Lost500 Survey, A-74" the constant isn't a given position but the number values following "A-" again thanks for...

Hi everybody! the title says it all, i have a text field that contains a name then an Abstract number and i would like to get the Abstrat number (or the value in the string after "A-") so for example a record would show: Lost500 Survey, A-74 I would like to get the A-74 out of there!! there...

wow i hope ya'll are getting paid for this, it works perfect, thanks for leading me all the way through ya'll really are something special. thanks again!

Thanks PHV so i inserted the group by and now when i run the query it prompts me for parameter values for each of the additional fields i added i.e. SELECT dbo_tblTitleInfo.TitleType, dbo_tblTitleInfo.Author, dbo_tblTitleInfo.UnitTractNumber, MinimumDate FROM dbo_tblTitleInfo T INNER JOIN...

Thanks for the quick response and thanks for the education! ok so it turns out we're talking about TractName not UnitName but here is the code i tried: SELECT dbo_tblTitleInfo.TitleType, dbo_tblTitleInfo.Author, dbo_tblTitleInfo.UnitTractNumber, MinimumDate FROM dbo_tblTitleInfo T INNER JOIN...

Thanks lespaul so i have a stupid question, what does A stand for? thanks again i think we're getting close.

Hi all, I am running a query where i would like to find a minimum date in a group of records and also include some other fields with it. the problem is when i add more fields to my query they are defaulted to group by so, where i want to see the Unit name for the record with the min date, i get...

so i looked into the misspelling, and i just can't spell but, i misspell consistanly so that is the actual field name... i can tell now after reviewing the results that the 475 number is the correct record count im going for and the additional records are duplicates steming from...

ok here it is, there is alot but really its just pulling fields from a couple tables using the criteria of a specific unit name and that a couple of check boxes are false, this is in access and i view the results in a dataset and then i just highlight a column and click sort and the record...