View Single Post
  #3  
Old January 15th, 2010, 01:49 PM posted to microsoft.public.access.tablesdbdesign
kaw via AccessMonster.com
external usenet poster
 
Posts: 10
Default need help with query or report

The box is paperwork from taxpayers. For example, we scan forms in house, as
we scan, we give it a number that is the number that I use. I bundle all the
papers together that is processed in one day.
My scanned form table has columns: Batch number, scanned date, deposit date,
form type, number of items, batch source, batched by, amount, rebatched
number, employee check out.
I have not set up any relationships for each table.
I would like to create either a form or query that is either by box number
and or dates. Hope this helps.

Gina Whipp wrote:
Kaw,

I can't see how you determine what's in a box. A wee bit more information
will be needed... Tables and how they are related to each other. How does
the database know which box they are in? Is there a field that indicates
that?

I am needing to print out an inventory list that is in a box. I keep track
of

[quoted text clipped - 7 lines]
to
print out what is in each box.


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201001/1