Combining data into summary report

Just do a search for "microsoft access tutorials" and you'll find plenty of resources from books, classes and on-line resources. Here's a couple to get you going:

http://databases.about.com/cs/tutorials/a/widgetmenu.htm

http://www.functionx.com/access/

Cheers.

RW

visual basic in excel and visual basic in access are the same.
only difference is the queries in access, since you are fairly advanced in access scripting what you want shouldn't be difficult at all.

forget all the software you are using, and lets start over.

On the internet, there is Quick Basic dangling around on some sites. Download it and then make a program like this:

------- Code starts here -------
open "database.txt" for output as #1
do
input "Enter item name or * to end: ",item$
if item$ <> "*" then
input "Enter item location: ",iloc$
input "Enter number in stock: ",inum%
print #1,item$,iloc$,inum%
end if
loop until item$=""
close #1
------- Code ends here -------
The above creates your database in a good format.
The next piece of code reads it and determines what percent of the total each item is.
------- Code starts here -------
open "database.txt" for input as #1
print "Item name","Location","Count","Percentage"
do until eof(1)
input #1,item$,iloc$,inum%
tinum&=tinum&+inum%
loop
seek #1,1
do until eof(1)
input #1,item$,iloc$,inum%
print item$,iloc$,inum%,tinum&
loop
close #1
------- Code ends here -------
If you look at the database file of "database.txt", you can see it is nicely laid out. Plus, your system will not slow down on you since this can be easily pulled off on a 386 computer. LOL ;)