Search results

I am coming up with errors when I'm importing from Excel to Access. The error message is "field truncation." The way I saved my Excel Sheet is in Tab Delimited so that all my data comes through, otherwise, most of my data is eliminated. What do I need to do so that all my data comes through...

I am coming up with errors when I'm importing from Excel to Access. The error message is "field truncation." The way I saved my Excel Sheet is in Tab Delimited so that all my data comes through, otherwise, most of my data is eliminated. What do I need to do so that all my data comes...

Question: I am a newbie to Access, and wonder if someone could give me a hand with a query I am trying to create. If I can beg your indulgence, my problem is as follows: I have two tables, one with names and date ranges, as follows: John Smith 4/1/01 6/1/01 John Smith 2/2/98 3/2/98 Irv Jones...

Queries with Null Values You figured this out for my co-worker and it does work like a charm. Now I would like to pose this question for you using the same table. I have Null values in which I do not want to show in the query (meaning, if client John Smith was seen on two different dates and...

I'm running a query wherein I have a null value in a field. What I want to do is when there is a null value in a field, i want the entire row not to show. Any suggestions on what I should do is appreciated.