A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

need help with query or report



 
 
Thread Tools Display Modes
  #1  
Old January 14th, 2010, 09:50 PM posted to microsoft.public.access.tablesdbdesign
kaw[_2_]
external usenet poster
 
Posts: 4
Default 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.

  #2  
Old January 15th, 2010, 01:39 AM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default need help with query or report

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.



  #3  
Old January 15th, 2010, 02: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

  #4  
Old January 15th, 2010, 03:19 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default need help with query or report

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



  #5  
Old January 15th, 2010, 03:54 PM posted to microsoft.public.access.tablesdbdesign
kaw via AccessMonster.com
external usenet poster
 
Posts: 10
Default need help with query or report

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

  #6  
Old January 15th, 2010, 08:27 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default need help with query or report

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



  #7  
Old January 15th, 2010, 09:51 PM posted to microsoft.public.access.tablesdbdesign
kaw via AccessMonster.com
external usenet poster
 
Posts: 10
Default need help with query or report

Okay here are all four tables Every thing is test box except amount that is
currency
tbllockbox (Name of Table)
lockbox number (Primary Key)
Packet number
Deposit date
Form
Check
No Check
Correspondence
Amount
Rebatch Number
Box Number
Employee Check out
(need to print inventory by box number)

tblscanfile (Name of Table)
Batch number (Primary key)
In Date
Deposit Date
Form Type
Number of Items
Batch Source
Batched by
Amount
Rebatched
Notes
Employee check out
(need to print monthly for book)

tblmanualfile (Name of Table)
File number (Primary Key)
Amount
Deposit Date
Form
Employee
Rebatch number
Employee check out

tblcasefile (Name of Table)
Folder Number (Primary key)
Yr Received (use month and year only)
FEIN number
Company name
Auditor name
Box (box with auditor name and number ( 1-10 ))
Employee checkout
(need inventory of what is in box by auditor)


Gina Whipp wrote:
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.

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

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


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

  #8  
Old January 16th, 2010, 04:58 PM posted to microsoft.public.access.tablesdbdesign
Gina Whipp
external usenet poster
 
Posts: 3,500
Default need help with query or report

Kaw,

I can see an issue right off the bat... You based your table design on what
goes in the box, a flat file like doing it in Excel, instead of a relational
design with normalized data. That is why creating reports is difficult if
not almost impossible because these tables can't *talk* to each other.
Unless I am misunderstanding something...

It looks like to me all these items (your different tables) are in boxes
together and you want a report that says what's in the box? Yes, you can
create a report for table tblLockBox but there is nothing in the other
tables to help you know which Box those are in.... Again, unless I am
misunderstanding something...

--
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:a229eb7b8fcf2@uwe...
Okay here are all four tables Every thing is test box except amount that
is
currency
tbllockbox (Name of Table)
lockbox number (Primary Key)
Packet number
Deposit date
Form
Check
No Check
Correspondence
Amount
Rebatch Number
Box Number
Employee Check out
(need to print inventory by box number)

tblscanfile (Name of Table)
Batch number (Primary key)
In Date
Deposit Date
Form Type
Number of Items
Batch Source
Batched by
Amount
Rebatched
Notes
Employee check out
(need to print monthly for book)

tblmanualfile (Name of Table)
File number (Primary Key)
Amount
Deposit Date
Form
Employee
Rebatch number
Employee check out

tblcasefile (Name of Table)
Folder Number (Primary key)
Yr Received (use month and year only)
FEIN number
Company name
Auditor name
Box (box with auditor name and number ( 1-10 ))
Employee checkout
(need inventory of what is in box by auditor)


Gina Whipp wrote:
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.

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

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


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



  #9  
Old January 19th, 2010, 05:03 PM posted to microsoft.public.access.tablesdbdesign
kaw via AccessMonster.com
external usenet poster
 
Posts: 10
Default need help with query or report

I think that maybe correct. I am trying to use Access as an inventory system
but my files only move once a year. Do you have any suggestions that may work?
I am trying to quit using RedBeam
Check In/ Check Out because it gets quite full and quits working then I have
to pay them to update the database. The last time it took 9 months before
they got it right. I cannot operate like that it gets me behind.

Gina Whipp wrote:
Kaw,

I can see an issue right off the bat... You based your table design on what
goes in the box, a flat file like doing it in Excel, instead of a relational
design with normalized data. That is why creating reports is difficult if
not almost impossible because these tables can't *talk* to each other.
Unless I am misunderstanding something...

It looks like to me all these items (your different tables) are in boxes
together and you want a report that says what's in the box? Yes, you can
create a report for table tblLockBox but there is nothing in the other
tables to help you know which Box those are in.... Again, unless I am
misunderstanding something...

Okay here are all four tables Every thing is test box except amount that
is

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


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

  #10  
Old January 19th, 2010, 05:04 PM posted to microsoft.public.access.tablesdbdesign
kaw via AccessMonster.com
external usenet poster
 
Posts: 10
Default need help with query or report

I think that maybe correct. I am trying to use Access as an inventory system
but my files only move once a year. Do you have any suggestions that may work?
I am trying to quit using RedBeam
Check In/ Check Out because it gets quite full and quits working then I have
to pay them to update the database. The last time it took 9 months before
they got it right. I cannot operate like that it gets me behind.

Gina Whipp wrote:
Kaw,

I can see an issue right off the bat... You based your table design on what
goes in the box, a flat file like doing it in Excel, instead of a relational
design with normalized data. That is why creating reports is difficult if
not almost impossible because these tables can't *talk* to each other.
Unless I am misunderstanding something...

It looks like to me all these items (your different tables) are in boxes
together and you want a report that says what's in the box? Yes, you can
create a report for table tblLockBox but there is nothing in the other
tables to help you know which Box those are in.... Again, unless I am
misunderstanding something...

Okay here are all four tables Every thing is test box except amount that
is

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


--
Message posted via http://www.accessmonster.com

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.