Search results

Sorry, the tables

I have attached my original 3 tables (Access 97) for you to take a look at. The 3 tables are linked by pubID. Thank you so much for your help on this ******* I did what you said to do with the tbl_species and tbl_waterbody, which has given me: tbl_species_new: SPECIESID (autonumber)...

I have attached my original 3 tables (Access 97) for you to take a look at. The 3 tables are linked by pubID Thank you so much for your help on this ******* I did what you said to do with the tbl_species and tbl_waterbody, which has given me: tbl_species_new: SPECIESID (autonumber)...

I understand up until: "For the tblOccurance you have to create a query in which you select data from five tables (your three and the two newly created). Join the two newly created tables via WATERBODYNAME and SPECIESCODE. Then put just the two newly created primary key in the selection. At...

Norbert, Sorry, still I little confused Could you be more specific (ie: what tables, fields) Your help is greatly appreciated - you are a lifesaver Sue

Norbert, Sorry, still I little confused Could you be more specific (ie: what tables, fields) Your help is greatly appreciated - you are a lifesaver Sue

Thanks Thankyou to you both for your reply. I would like to change my database structure to the design illustrated in "species.gif" Not sure how to transfer my data in its existing structure to the structure in "species.gif" - any not lose the links between the data. In my existing structure...

I will try my best to describe my table relationship: tbl_FW_Main ID (autonumber) PubID (Primary KEY) Title Department Date_Published Publisher Report_Location Authors Tbl_Waterbody ID (autonumber) PubID (foreign key) WaterbodyName Watershedcode AliasName etc Tbl_Species ID (autonumber)...

Thanks for your reply - it solved my question

can someone tell be how I can place a "0" in front of all records in a text field ('lon'). I tried to update to: Right$([lon],Len([lon])+"0") in an update query - i didn't get an error but it did not add a "0" to the beginning of the records. any ideas - thanks sue

I compacted my database, no prob just curious to know why it got so large when I converted it ideas?

Hi all, My database seems to have changed size (and the data it contains has not really been changed). I converted from Access 97 to 2000 and it went from 6.07 mb to 372mb Any ideas on what happened and how I can change it? Thanks, Sue

How to update number field in "many" table from autonumber field in "one" table I solve this problem a long time ago - I can't remember how I did it though! For example Table 1 Main ID (autonumber) field1 field2 field3 Table 2 MainID HabitatID Table 3 Habitat ID field4 field5 field6...

I have never had this problem before... I am trying to import an excel spreadsheet..... I get the error message "error trying to import file " ". the file was not imported. it doesn't give me any more detail than that (ie: import errors table) i tried to import just one of the fields from...

Aftter a bit of fiddling - the following extracted the "time" values from my field: Time: TimeValue([Start date])

Hi all, I know how to extract date values, but does anybody know how to extract time values? (have already searched for the answer on these forums) For example: The records in date/time field look like: 1/4/89 1:45:00 PM I want to create 2 fields, one for the date, and one for the time...

Thanks jfgambit!!! You're a genius, I have no idea how you figured that out! You above post worked like a charm You made my day:)

What I want to do: Where records in "field a" are the same - i want to make records in "field b" the same. Also - I want the records in "field b" to be the same as the first record were "field a" starts to be the same. Maybe I'll just show you what I want: An example, How it is now...

Good Advice Thanks for taking the time to respond

Easy question.... Ive just been sent an Access db. It consists of one table with 4 fields. (location name, location type, watershed code, species, years available) Two of the fields "Species" and "Year available" contain codes recorded in the following format: ct, act, dv, st or 69, 72, 80-82...