How do I combine Tables without losing data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm having a problem. When I make a query some of my rows get deleted. I
think this is happening because there is 0 in some of my fields. I don't
want it to delete that row I want to see it say 0. How do I keep my data
from disappearing.

Thank you for any help you can give me.

R/S
 
Dear Jervon:

"some of my rows get deleted"

Just because some rows are eliminated from a query does not make them
deleted. Does the query have any creteria? These would omit displaying
certain rows. Does the query have grouping? This will condense the data to
have fewer rows.

If you wish some help here, I recommend you do these things:

1. Post the SQL text of the query involved.

2. Post some of the data that represents something being omitted.

Looking at these things, prehaps some explanation and remedy would be
possible.

Tom Ellison
 
Back
Top