lets say i have a table that lists every light bulb in the building. i also have a order table with date and amount of bulbs ordered fields and of corse one that links to the specific bulb

what i want to do is create a report that lists all bulbs and accumalates the total amounts ordered

what do i do

in these forums its hard to teach access. the forums are for specific difficulties that some one has with creating something, maybe trouble shooting some other issues.

i suggest you buy yourself a book and learn a bit more about access.

sam