Recent content by fido77777

thanks for everyone tried to help me but i solved the problem myself 1-i created a table with self join 2-entered the first employee id as value in list box on a form 3-used loop statement (do while - loop) 4-within the loop i added a SQL statement to query the manager of the employee...

@The_Doc_Man thank you for your reply but it is already done the table and the self join please check the first post here and then imagine (z) made an order i need to run a query to find out that (y) is Z's manager and run the query again to find that (x) is Y's manager and so on from the...

why i want to do it let's say z is sales he gets a percent for sales and y gets a percent and x percent coz z works under y who works under x i need to know that series of levels of management before i calculate sales percent i wish i am more clear now and any suggestions or help will be great

i have a table with employee details which include column for manager which is employee too something like that : empid---- name----- manager 1 ----------x 2---------- y---------- 1 3 ----------z---------- 2 4----------...

i need to create 3 reports and allow the user to change printer and paper size without default access tool creating a dialog box for that can that be done and how? i want it to be different settings for each report

thanks for your help it was really helpful but i am doing it as an example on queries my only problem here: that i want to replace the 3 queries with only one select query to get the job done is it possible or not?

i have that product details table contains different quantities for each product (quantities i received in different dates) i have that order details table contains different quantities for same product (quantities i sold in different dates) now to find the amount left from each product i...

i have this textbox that contains an equation i want to store the equation result in a table the control source is set to the equation so i can't pass the value to the table field anyone can help?

i know how to set picture as report background and how to import report in MS word but is there a way to have options in report deign like in word to edit background and set text or picture as water mark

i have a report which contain a lis of products sold and its cost it contains many pages i want to sum each page at the end of it and use the sum at the next page as start value to be sumed with the following values some thing like for example 2nd page of report...

i have the basic concepts and information about macros but i need a detailed information about all macros i need a book or tutorial cover macros in access in details

in fact your way is better that would allow user to change the min and max and rate values if he had to in the future i was just wondering if the loop can get it done thank you for your help

thank you a lot pbaldy many thanks too for every one helped me here i have created the new table with 3 columns: min, max and rate and put the dlookup in the control i wanted and it works really great problem solved my thoughs was about using a loop to solve the problem something like...

it so close to what i want really i want it done on a control on form no problem using one more table but can u put an example please to make it more clear for me thank you for your help

i think it was my mistake that i am not clear enough the problem is not in the tax part it is only an example i will try to be more clear if i have invoice if it says 1000 so the tax calculated = 1000*.5% if it says 2000 so the tax calculated = 1000* 1% if it says 3000 so the tax...