Recent content by crayfishgirl

Thanks much for all your assistance everyone! Using CraigDolphin's code the Taxa names are all in a single column and I can proceed with the analyses....and I don't think I changed anything in terms of making cells null? Regardless, I'm very appreciative. Have a great day... camille

Thanks Jon I think that's the problem.....the cells with missing information aren't null. How do I go about making them null (I thought I have done that with the "")? camille

Thanks Doc Man This is where I am now. I tried the union query on my test table and changed "order" to "iorder". Unfortunately, it still only pulls the Genusspecies names regardless of any commands after that. I've done the query in stages in the hopes I can get a hint as to where the issues...

I'm afraid this still isn't working. I have 91,000 records in the table I want to so I created a new small table to test the theory that the empty cells aren't truly null. I made sure the cells where Genusspecies were missing were null by putting "" into those that were empty. That's correct...

Thanks Neil...you might be right about the 0 length string because your code isn't working either (and I think it should actually give me what I want). Is there a way to make the cells in the original table null? camille

Thanks Jon....but it still didn't work. The Genusspecies name is being returned but empty cells where Genusspecies is absent/null. Help again??

I'm hoping this will be an easy question for most people. I have a query with three text fields of insect names (Genus species, Family, Order). In some cases, where the the insect could not be identified to the Genus species level, it was identified at the Family or Order level. I'm...