Problems with two tables cont...

  • Thread starter Thread starter James
  • Start date Start date
J

James

Please could any one willig to help read the below as I
think it would help in the sense of what I have done and
what others have tried in helping me solve this issue.

Many Thanks

James

-----------------------------------------------------------

Would you like me to send you a copy of the database would
this help any?

Many Thanks

James
 
No. A UNION query consists of two (or more) SELECT statements
selecting fields from two tables or queries. The fieldnames can be
different, the field lengths can be different; however, the two SELECT
statements must have the same total number of fields, and the
datatypes must match up - that is, if the first field in the first
Select is a Number, the first field in the second Select must also be
a Number. Vanderghast correctly points out that using the word NULL as
a "calculated field" will work, since NULL has no datatype.

We're trying to help you, James, but you're making it very difficult.
Could you possibly consider posting the SQL view of the query, and the
specific problem that you're having?
If Yes then is there another way as
this
Click to expand...

Bear in mind: NOBODY HERE KNOWS WHAT YOUR TABLE CONTAINS. You have not
mentioned any fieldnames; what "forename" and "surname" contain in
your two tables is a complete mystery to us. YOU can see your computer
screen. We cannot. We're not telepathic.

If you can - again - describe what you're working with and what would
"make the query work", it's quite possible that there is.
 
Back
Top