Search results

Same data, but because of it now being normalized I believe it is a different issue. The normalization process was rough since I inherited the database and had to go through and normalize it to the best of my ability. Plus I believe the previous post was for the select query whch was indeed...

not sure if it posted or not. if not here it is again

Here is the database. I removed all the location information as well as notes so when running the select query it will throw up the windows asking for the various data i removed but still runs correctly. Use the form CrocIDlookup to run the select query. I need to rearrange the forms for my...

Minty I have attached a screenshot of the table relationships. Plog, thanks I will look into that. When I was researching this I came across that link but wasnt sure if that was the method I should use or not. jdraw the database is for tracking crocodiles. The SQL code for the biological info...

Hey all, I have a database composed of 5 tables (ID, Location, Biology, Other, Crocodile) as well as a join table called Lookup. The tables are self explanatory for the info in them. The crocodile table has each individual animal(as an auto number) and its sex. ID table includes markings tags...

@jdraw Thanks!! and thank you for the link. Ill definitely look into that.

@CJ yeah I wasnt sure what i was going to have to make the form search for in the database so I coded one at a time and basically copied it and replaced variables as they needed to be replaced. Thanks again for all of your help. My next goal is to clean up the database a bit and make it easy for...

Thank you EVERYONE! all of the help is much appreciated if I have any other unrelated issues arise then Ill make another thread. This was the final working code. And (("/" & Crocodile_ID.[S] & "/") Like "*/" & replace(Nz(Forms![Search Crocodiles]!S,""),"/","/*") & "/*" Or Forms![Search...

@jdraw I agree the table is not well designed. Again I inherited the database but the database is a work in progress. I have full access and can modify things that need to be. The form should allow someone to enter what they know about the crocodile(s) scute markings, tag number and the output...

Mark, having not used that function before I am unsure where to put it in the code. Ill do some research and try to figure it out :)

CJ null values are still throwing an error. then again I havent utilized the nz function yet. Thank you so much for your help and I am sorry if I am being a pain. This is literally month 2 of me using Access.

CJ I have attached a sample of the data. The data in the table is only numbers and slashes. The end goal is to be able to input part or all of the scute pattern and return the animal(s) that have that pattern and all pertinent information for those animals.

Minty thanks!!! Had no idea I could do that! ok here is the bare minimum of my data. The croc search form has the various means of searching. Im only concerned with the S, DL and DR fields right now.

unfortunately with compression and removal of my other forms and queries as well as a removal of over 200 entries I can only get the compressed file to 34 MB

The problem with doing this is that the data for the animal is all in one line GPS location other identification information as well as location info and notes.As well as other instances where the animal was recorded which would be a separate line with different information such as GPS ect...

CJ I have also looked at your second code that you gave me and tried it without the mid function but it doesnt seem to work. Oddly enough your first code works on everything except 1/x (and nulls). Speaking of nulls the error I get when the field is left blank is "the expression typed is...

Ok I just got into the office. Here is an example of data from the table: 4/10/12 7/8/10/12 5/9 4/11 11 3/10/12 7/10/12 2/10/12 9 9/13 I am unsure of another way to store this data as each number has to be separate as in 2/10/12 cannot read 21012. The data will then be combined with two other...

Mark, It would not have to return 8/10 or 10/12. so if the patterns Im running the query on are: 7/8/10/12 8/12 8/10/12 7/12 8/10 10/12 then running the query using 8/12 will still just return 7/8/10/12 8/12 8/10/12 However if I only know 8 then the query should return everything with an 8 in...

jdraw, As I am currently not at the office (8 pm est here) I cannot access my data but the examples I gave were real examples. I can get more examples tomorrow however. The variation can go from a null all the way up to 5 or 6 numbers. No one number will be repeated in a sequence and the...

Mark, Yes I could potentially have a 1/12 I could also have a 1/4/8/10/12. A few of them were entered with 0s as well for some reason. So 0/5/7 is also a possibility. I think Ill have to remove the zeroes from the table later I inherited this table from my predecessor