need help with query or report

I am needing to print out an inventory list that is in a box. I keep track of
paperwork by using numbers from various sources (not able to change the
sources) but each source has a number given to it. I keep each source
serapate from each other in didferent boxes. I need to print out an inventory
list that is in each box. I am just beginning using Access 2007. I have all 4
tables with data from each source ie. scanned forms, audit files and need to
print out what is in each box.

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?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kaw" u57493@uwe wrote in message news:a21d5597a5e41@uwe...
I am needing to print out an inventory list that is in a box. I keep track
of
paperwork by using numbers from various sources (not able to change the
sources) but each source has a number given to it. I keep each source
serapate from each other in didferent boxes. I need to print out an
inventory
list that is in each box. I am just beginning using Access 2007. I have
all 4
tables with data from each source ie. scanned forms, audit files and need
to
print out what is in each box.

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

Kaw,

Thank you for telling what you do and how ou do it. I also see you posted
some table information in your reply to Karl. However, still.. a wee bit
more informtion is needed... Each table with their prospective fields is
needed so we can provide you with a solution and make sure your tables are
set properly to give you the results you desire.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kaw via AccessMonster.com" u57493@uwe wrote in message
news:a2263bd6f49b3@uwe...
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

would it help if I emailed screen prints? I am a newbie to Access so not sure
what you need.

Gina Whipp wrote:
Kaw,

Thank you for telling what you do and how ou do it. I also see you posted
some table information in your reply to Karl. However, still.. a wee bit
more informtion is needed... Each table with their prospective fields is
needed so we can provide you with a solution and make sure your tables are
set properly to give you the results you desire.

The box is paperwork from taxpayers. For example, we scan forms in house,
as
[quoted text clipped - 23 lines]
to
print out what is in each box.

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

Kaw,

No screen shots won't help... Here's what I am asking for

tblNameOfTable
NameOfField
NameOfField

tblNameOfTable
NameOfField
NameOfField

Do that for all four tables. Indicate if any of the fields are Primary
Keys.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"kaw via AccessMonster.com" u57493@uwe wrote in message
news:a226cca994709@uwe...
would it help if I emailed screen prints? I am a newbie to Access so not
sure
what you need.

Gina Whipp wrote:
Kaw,

Thank you for telling what you do and how ou do it. I also see you posted
some table information in your reply to Karl. However, still.. a wee bit
more informtion is needed... Each table with their prospective fields is
needed so we can provide you with a solution and make sure your tables are
set properly to give you the results you desire.

The box is paperwork from taxpayers. For example, we scan forms in
house,
as
[quoted text clipped - 23 lines]
to
print out what is in each box.

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