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. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|