Search results

Re: Query to show only current week good morning how can i make a conditional report that can give me some data from the table

dear pr2 ; thanks for your respond ; the two tables has different data i need to union them but i dont know the sql statments;

Good Morning every one; i have two tables as the following : table 1 fields : customer_name, type , qty , price , total , delivery_no , delivery_date , grade table 2 field : customer_name, type , qty , price , total , delivery_no , delivery_date , grade ** i need to make query that get the...

i did the two query but how i can make the subtract query

i al ready make the query but i have a small probleme that i need to add a new column that calculate the defference between the total column from the forst table and the all paid columen in the second table ...... ** any idea **

hi every one ; my regards for you; i have two tables the first have these fields : CUSTOMER_QTY TRUCK_NO DRIVER TRANSPORTER CITY CUSTOMER_NAME TOTAL PRICE_TON QUANTITY_TON TYPE BAGS_NO TRANSPORTER_NO DELIVERY_DATE DELIVERY_NO NO the second tables have these fields : 1. customer_name...

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...

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

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

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

Waiting for your feedback

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

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

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

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...

thanks for you interesting finally it's work good

Hi every one i want to group by week , month , customer_name, type so what;s the wrong in my code : SELECT U.[Customer_Name], Sum(U.[Quantity]) AS SumOfQuantity, U.[DeliveryWeek], U.[DeliveryMonth], U.[TYPE] FROM (SELECT Customer_Name, Quantity, Delivery_Date, ,Datepart("ww",Delivery_Date) AS...

thanks very much for your support

i want the total quantity for every customer in the month ) thanks again

I'm waiting for you feedback