Search results

Thanks for your help :)

RICH, Can you be more specific about following : "You can join table 1 to table 2 in a query on watershed code " I have added both tables to the query design view. They are joined by an "ID" field in both tables. I dragged the watershed code from table 2 and the gazetted name from table 1 to...

I have 2 tables Table 1: Fields: Gazetted name (ie: Hope) Watershed code (ie: 1041) Table 2: Fields: Watershed code (ie: 1041) Field 1 Field 2 Field 3 In table 1, each gazetted name matched a watershed code (ie: fraser river = 1041, hope river = 1521) As the end result, I need to add...

I have one field in a table which contains the date in the following format: mm/dd/yy The table I need to append this data to, however, structures the date data differently. There are 3 separate fields: year, month, day Is there anyways I can import the mm/dd/yy field into the year, month...

THANKS! Thanks Jon! Thanks for taking the time to answer my question, it worked!

I understand that I need to create a update query, I just dont know how. It seems that I need to have 2 "where" criterias (but then again what do I know)I get confused at the "update to" part of the query grid. The blank or 0 records of table main, field meta_data_id need to be updated by...

one more thing i just wanted to add that there are 2129 blank records in the field to be updated, just the exact amount I want to add

Hi, I would like the update the blank records in a field, but with sequential numbers, from 13-2141. (ie: the first blank record would be updated with the number 13 and the last blank record with the number 2141) How can I change the following sql stament to get the results I want: UPDATE...

Sorry, i posted new post instead of reply to post, Here is my original question: I need to append records 11709-13847 from the field "Main_id" to records 1-2139 in another table (Barriers). I don't want to simply add on the records from "Main_id" to my barriers table. How can I do this...

Would it be possible for you to show me the exact sql commands to use ? Thanks - I am not having any luck with the command snytax you gave me

main id is an autonumber field Main_id is an autonumber field in the main table and a number field in the barriers field (table i am trying to append to) There aren't records with Main_IDs 1-2139 Does this make a different to the sugguestions in the above post? I am using access 97 - I am...

I don't know how I should do this with out manually typing in each record. I have a field (data source) that from records 11709-13847 is blank. I need to add the same data source code (FISS) to all these records. How can I do this, I am using access 97. Thanks for your help. Sue

Hi there: I need to append records 11709-13847 from the field "Main_id" to records 1-2139 in another table (Barriers). I don't want to simply add on the records from "Main_id" to my barriers table. How can I do this? The reason I want to do this is because the records in the Barriers table...

thanks rubyred :) thanks for the answer - that was easy !

Thanks to those that have answered my questions in the past, they have really helped! My question: I have already created form and have it exactly how i want everything to look. I now have realized that I should have added an extra field to my form - ie : field "comments" Is there anyway i...

Hi there - When I add the following tables to a query design and the fields from these tables - it works fine (i haven't listed all the fields in the tables, just the primary keys to illustrate how the tables relate to each other) TABLE 1: MAIN_ID TABLE 2: FISH_ID MAIN_ID TABLE 3...

alex the previous post didn't include the fields that were in the tables - i was just trying to illustrate how the tables related to one another. I am trying to create a form (s) where I can enter data from fisheries-related paper records - the problems is is that the records contain data...

one more thing... i need my forums for data entry thanks

More info for alex I figured out how to base a form on a query (which has fields from different tables) - i got it to work once or twice - but sometimes form wizard doesn't ask about subforms - and when i open the form it is blank..any advice on setting up queries? anyways, back to what i want...

Two questions: I have read posts where users refer to using 'codes" in forms - what are they talking about and how do you use them (i am just using form wizard in access 97) I am trying to create a form that contains fields from different tables (about 4 or 5 tables) - i am running into...