Join Data Between Two Tables

[Galaxiom]

so what;s the wrong in my code

It would help if you said what was wrong with the result. Does it fail with an error or do you just get unexpected results?

 

[moustafa]

thanks for you interesting finally it's work good

 

[moustafa]

NOW how can i share my database with another user on my office network
note: i copied the database file in (C:\Users\Public\UMIC DATA BASE FILES)
and the computers on the network can see the file but there is small problem : the main table in the database is an excel file and i linked it to the database so when the another user want to open the database from his computer a message appear that can not find the path for the file >
thanks

 

[Galaxiom]

You don't share yourdatabse.

You Split it and then provide a separate copy of the Front End to each user. The Back End must be located somewhere that all users can connect to with the same path.

 

[moustafa]

ok i split it but i can not see the linked tables in the users computer i see the local tables only

 

[moustafa]

and i can not see any query in the database after split

 

[Galaxiom]

Put the tables in a network location that is visible by all using the same network path. Eg \\ServerName\ShareName

Link the tables to the Front End using that path. Then copy the front end to each user.

 

[moustafa]

how can i Link the tables to the Front End using that path?
and
what do you mean by front end to each user

 

[moustafa]

Waiting for your feedback

 

[RainLover]

from his computer a message appear that can not find the path for the file

Which file is that?

 

[moustafa]

HI every one i made a copy from db to the sever everyone can see it but there is a problem that just one user can use the db how can i make it multi user

 

[moustafa]

Who can i make macro that group all data for customer from 3 tables

 

[RainLover]

Who can i make macro that group all data for customer from 3 tables

It would help if you answered the questions as and when they are asked of you.

We do not know what you have working or not.

I would suggest that you have gone too far with this original question and that it would be good if you started a new thread and explained your problem. Just one at a time for each thread.

 

[moustafa]

good morning every body
i need to make a form that contain list box when i choose an item from the list box menu it display all data about this item from it's source table >>> can any one help me !!1

 

[moustafa]

Good Morning Every Body
i need to union two tables but my code not work can any one help me :
my code is :

SELECT U.CUSTOMER_NAME, Sum(U.Quantity_TON) AS SumOfQuantity
FROM (SELECT Customer_Name, Quantity_TON
FROM FELDSPAR
UNION ALL
SELECT Customer_Name, PREVIOUSE_BALANCE
FROM ACCOUNTING_FELDSPAR
) AS U
GROUP BY U.Customer_Name
ORDER BY U.Customer_Name;

thanks