Search results

Thank you!

Arne thank you! I was actually just going through and came up with something similar myself using your original equation. This is much cleaner tho. I am curious, is it possible to have the DR function ignore the 7, 8 and 9s? That is my next (and final) step. The 7,8, and 9's in those fields...

Correct, S is a field DL is a field and DR is a field three separate fields

Others know how to do the calculations as well. I would have to do the calculations for S, DL, and DR separately then add them together. The main goal in the thread though was to figure out how I can extract the number data from the various fields. I will definitely play around with Arne's...

haha sure thing. S 2/7/10 DL 5 DR 2/3 would convert to 1559. Starting with S. any number less than 9 would be added based on the description I gave. There is a wrinkle in this explanation as the actual data has a certain DR clip that signifies which agency made the clip. Ill explain that at the...

Short Text. Attached is the data for the SCPs that I pulled from the working database.

The error just says "#error" in the field after running the query. I couldn't figure out how to get an actual error code from it.

I tried this but it returned an error after it ran. But at least it ran

That is correct. The data must be able to be queried piecewise. As these animals are in the wild, when they are seen many times you only see partial data. Maybe it is on a few clipped scutes near the end of the tail maybe it's on the left or right side. That query works. The reason for pulling...

Mark, The reason for the data stored the way it is, is that it is infact a distinct sequence (similar to a bar-code or the scarring on a whale's fluke). It is just part of the overall unique scaring of the animal.

Ok I am still a bit lost. When I try running the split function I get an error saying that 'Split' is an unidentified function. I am attempting to run it in the query. Is split supposed to be used in VBA code as opposed to SQL? If so then I am even more lost than before because I have almost no...

Thanks all. Plog, the data is stored like that because that is how the data is taken. They are clip patterns on a crocodilian. stored as single, Double left and double right. each number represents a single scute that was clipped off an animal. The example I gave was for the single field. The...

Hey all, I am trying to split my data in a field and convert the returned values into numbers that i can then do some basic calculations with. Ill give you an example of what I need and what my end goal is. First I have fields that are set up in a specific way as part of an identification code...

Pat, Under the ID tab there is a text box called "State ID" and I have no clue where that came from. I have also added an add croc button to add new animals to the database. When there is a new encounter, such as a new date and location, but it is for the same animal, the Location ID does not...

Pat, It appears as though the DoO (Date of Occurrence) is not being associated with the biological info for the croc. basically if a croc is caught in location A with a length of 100cm in February and the same croc is handled two months later at location B and a length of 105cm...the two dates...

Thanks Pat, Im still not sure where State ID came from. Mike, Thanks for the upload. I am trying both out today and will try to get it to do what I want. Thank you guys and I do apologize about my late reply

Pat, When i try to enter a new croc I get an error saying that required information is not present in an underlying table. Basically says Im missing a FK. I have already gone through and made sure the relationships were correct. Also I am unsure where the "StateID" came from.I have attached the...

Pat, I am having trouble getting the Form to add data. I keep getting an error where the FK in a table is not updating properly. I have copied the tables and forms into a blank database to try and figure stuff out. Any advice on this?

Pat, thanks a ton!! I will look into the follow hyperlink method for the docs. Ill play around with stuff to get it to where I want and post what I have created for critique before adding it to the "live" database.

Pat, That looks pretty close to what Im looking for. I am using the form more for updating the data or adding new data rather than looking up the data. I have another for that runs a query on the data in order to look up what is needed. That being said the croc ID lookup is exactly what I need...