accessgebruiker
MIS
Hi
Presumably there is some common field in your three tables to allow you to make a join?
But to get the three fields concatenated as one, make a calcualted field:
SELECT All3:Computer.MSE & Monitor.MSE & printer.MSE FROM Computer .... etc with your join and WHERE clause
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
accessgebruiker (MIS) Sep 25, 2002
Thanks for your information
I'm sorry but that didn't work out.. I think I do things wrong , couse I'm nog very good in sql. But let's make it more simple.
I make a query with three fields. no1, no2 and no3
how do I put these together in just one field.
William
I think this is a very stupid question... but I'm a little newbee in SQL... And in Access they use Jet-SQL..
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
KenReay (Programmer) Sep 25, 2002
Hi
Sorry I jumbled it a bit, should have been:
SELECT Computer.MSE & Monitor.MSE & printer.MSE As All3 FROM Computer .... etc with your join and WHERE clause
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
accessgebruiker (MIS) Sep 25, 2002
Yeah thanks a lot.....
It do work... but ehmmm I think you're misunderstanding my question...
What I'm getting now is bv:
computer monitor query but what I want is:
5 11 511 5
10 12 1012 10
11
12
I hope this will make things clear..
But thanks...anyway
William
Presumably there is some common field in your three tables to allow you to make a join?
But to get the three fields concatenated as one, make a calcualted field:
SELECT All3:Computer.MSE & Monitor.MSE & printer.MSE FROM Computer .... etc with your join and WHERE clause
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
accessgebruiker (MIS) Sep 25, 2002
Thanks for your information
I'm sorry but that didn't work out.. I think I do things wrong , couse I'm nog very good in sql. But let's make it more simple.
I make a query with three fields. no1, no2 and no3
how do I put these together in just one field.
William
I think this is a very stupid question... but I'm a little newbee in SQL... And in Access they use Jet-SQL..
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
KenReay (Programmer) Sep 25, 2002
Hi
Sorry I jumbled it a bit, should have been:
SELECT Computer.MSE & Monitor.MSE & printer.MSE As All3 FROM Computer .... etc with your join and WHERE clause
Regards
Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use
Mark this post as a helpful/expert post!
Inappropriate post?
If so, Red Flag it!
Check out the FAQ
area for this forum!
accessgebruiker (MIS) Sep 25, 2002
Yeah thanks a lot.....
It do work... but ehmmm I think you're misunderstanding my question...
What I'm getting now is bv:
computer monitor query but what I want is:
5 11 511 5
10 12 1012 10
11
12
I hope this will make things clear..
But thanks...anyway
William
