Dear, i used to write Databases USinf Foxpro Before and we upgraded to SQL 7 And VisualBasic 6 and i face a realy hard problem which is...

Dear, i used to write Databases USinf Foxpro Before and we upgraded to SQL 7 And VisualBasic 6 and i face a realy hard problem which is Microsoft data reports that Access SQL server 7. When there are many Tables are included and some Statistical function are required to be calculated not ordinary one like some and count it becomes so complicated my question is there any way to access Microsoft data reports using Code instead usin Queries and Direc table for Example in hotel mangemenet database i need to calculate how many guests i have from each country and how many rooms they occupy and the percentage of occupation for each nationality. so i need to calculate the total number of guests from each nationality and divide that number with total number of guests of all nationalities which can't be done one by QUiry cause we have different conditions + these informations are not in only one table so if u any of u guys has a sloution for my problem or even want to talk about it plz message me my Email f**l@hotmail.com