Search results for query: *

I created this extremely long query that still needs some more lines added but works so far. It will grow because I have to do a large amount of where statements for InfoType and Gear fields as well. SELECT POLYGON_ID, "Halibut" AS Species,"CO" AS Interviewer, PARTICIPANT_ID, GEAR FROM...

Hi duane, I tried out your statement and it works great and solves one of my issues - that of how to get yes/no fields into a text field. However I am having higher level problems. I am a little rusty on SQL so bear with me. I need to get information from certain fields in my Fishery table...

Yes if there is more than 1 value that is true then i would like to create more than one record in the new table. I still have to figure out a way to copy the values from the rest of the record onto the next row. just a quick thanks duane, i will try this out later today.

Hi there, I have a large table (FISHERY) where there are a number of fields with boolean data types. I am trying to figure out how insert those values into one field in a new table's (GIS) field named species that is a text data type. Example would be if FISHERY.Halibut= true then GIS.Species...

I also get this msg while trying to connect. I'm unsure of what settings to change to make this stop.

A week ago i used my personal laptop at work. I had to map to a network drive. Since then I have disconnected that drive but ever since then the Broadband Connection wants to continuously connect. It interrupts my internet connection all the time. I've attached a screenshot of the error msg...

Hi again, Thanks for all your responses! fneily, I tried to search but I guess I wasnt using the right terms because I couldn't really find something that answered my question. I'm still pretty new to this so odds are the answers were there but I just couldnt understand them. Plus I was...

Alex, I'm pretty new to this but i'm not sure if that applies to my situation. The article you linked to discusses how to reset an autonumber field. I just want to create a new field that starts at '572' and counts up from there. One of my initial problems was that i already had one...

Hi again! I'm trying to create a field in a table that will increment by +1 each time. However the value of the first row has to be a number other than 1. I retrieve that value through the function Get_Location_No. Here is my code: Dim strSQL As String Dim tabName As String...

thanks! the next task is to update a field in a table with an incremental number starting at the value. where value = rs!location_no. ie if value is 548 i need the first record of Location_Number field to be 549 and +1 to each row. is there a way to do this with an sql update stmt? or is it...

Hi everyone! I'm trying to assign the last value in a field (location_no) to a variable. I am using a recordset and trying to get the value of the last recordset. I can get the recordcount but dont know how to use that to get that value from the cell. which method/ property will return the...

merci PHV.

I'm running a bunch of sql statements in the background when user clicks a btn. I'd rather not have 8 msg boxes automatically show up saying "you are about to update 427 rows" etc etc. Is there a way to programmatically turn them off? Apologies if this is in the wrong forum and the answer is...

Ahh, I see now. Thanks very much. All is fixed now and I am parsing the data in the insert query. -cjo

Hey Alex, That is the answer, Thanks! I formatted the loc_year field as an integer instead of date. The reason i need to split them is because I need to (eventually) insert the data from this table into an existing table that has fields for loc_year, loc_day, and loc_month. O f course, all...

I have a field [new_time] that displays full date and time like this: 15/05/2006 12:20:00 PM I'm trying to parse it up and insert it into new columns. I searched the forums here and found this thread: http://www.tek-tips.com/viewthread.cfm?qid=1257953 I've tried to incorporate the year...

Thanks for your help, I looked into having originally but hit a couple of beginner road blocks. I ended up using a sub query to get what i wanted: DELETE * FROM TELLUS_TEMP_UPLOAD WHERE COLLAR_LAT<(SELECT Avg(COLLAR_LAT) FROM TELLUS_TEMP_UPLOAD)-50 Or COLLAR_LAT>(SELECT Avg(COLLAR_LAT) FROM...

In my table I have 2 columns with x,y points and I need to remove any rows where there are 'wacky points' (basically points that are obviously not in synch with the rest of the points in the table). I'm trying to construct an SQL query that calculates an average for each column and then removes...

Thanks you two. Yes, UBound was what i was looking for!!! later

after some more research i found out about the Len method but when i try that i only get a type mismatch error on this line: length = Len(tmpLine) ? thanks craig