I have a table with two fields. and I want to create a form with a list of hyperlinks/buttons from field1 and if you click on it you'll see field two
example:
table
field1 field2
data test
123 ok
then the form should like this:
data
123
so that when you click...
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...
Hi everyone..
I have a problem and I don't know if its possible to solve this. Mabey someone can help me.
This is the problem
I have three tables:
computer
monitor
printer
In every table there is a field: "number".
What I want to do is this:
I want to put the fields...
For my work I had to make a database where you can put in all the computers, monitors, printers, supliers, ec..
All computers, monitors and printers have unique "mse numbers".
I made a table computer, a table monitor and a table printer. In all these tables I made a field MSE. But...
At my work they were using a database in access 97. But now we use access 2000. When we update the database he gives error. What should I do ?
If you need the code ... just ask
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.