var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: access project help
am taking a a online course and a requirement of the course is to create a database by self learning. There is no material to study so am having millions of questions.
I am suppose to create a customer/order database......well i have already created tables and forms .
am stuck in 3 questions where
1)a query to display the name of the products, services, suppliers
, which relates to more than one customers, along with
the name of the customers in a systematic way.
2). Now create a query to display the name of the customers who have more than one transaction
3) A report to combine the Last name, Middle name and First name fields as Full_Name (Alias name)
If somebody can help me ......i will really appreciate..ive searched in the net but could not find any....
Without knowing the structures of the tables, it's very hard to write a query using them.
Have a nice day!
here my tables
Originally Posted by Sinndho