|
| 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 |
|
#21
February 10th, 2009, 11:17 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Microsoft Access 2007 Update fields
Have you created a query that joins the two tables on Dept yet?
Thel wrote: The name are the same in both tables. The dept table is for inputing information, the user does not want to lookup the data she needs to put in. if she knows the dept nbr she wants it to put desc and glcode that match that dept. The coorsponding field are all of the same data type. It is wise to name like fields the same in different tables. It is not wise to use the "#" sign in a field name. Are the two Dept fields the same [quoted text clipped - 10 lines] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com 
|
|
#22
February 10th, 2009, 11:26 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Microsoft Access 2007 Update fields
I have made a query with all the fields. Should I delete the dept desc and
glcode from the employee table and then do a join on the fields. If they are not stored in the database employee how will I use them to print on reports? "ruralguy via AccessMonster.com" wrote: Have you created a query that joins the two tables on Dept yet? Thel wrote: The name are the same in both tables. The dept table is for inputing information, the user does not want to lookup the data she needs to put in. if she knows the dept nbr she wants it to put desc and glcode that match that dept. The coorsponding field are all of the same data type. It is wise to name like fields the same in different tables. It is not wise to use the "#" sign in a field name. Are the two Dept fields the same [quoted text clipped - 10 lines] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com
|
|
#23
February 10th, 2009, 11:33 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Microsoft Access 2007 Update fields
On Tue, 10 Feb 2009 15:26:02 -0800, Thel
wrote: Should I delete the dept desc and glcode from the employee table and then do a join on the fields. Yes. If they are not stored in the database employee how will I use them to print on reports? By basing the Report on a QUERY joining the appropriate tables. If you're assuming that a report must be based on a single table, you're making a very common mistake... but it is a mistake. -- John W. Vinson [MVP]
|
|
#24
February 10th, 2009, 11:47 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Microsoft Access 2007 Update fields
Only delete the duplicate fields after you are comfortable with the fact that
using a query with a join makes the fields available any time you want. Thel wrote: I have made a query with all the fields. Should I delete the dept desc and glcode from the employee table and then do a join on the fields. If they are not stored in the database employee how will I use them to print on reports? Have you created a query that joins the two tables on Dept yet? [quoted text clipped - 10 lines] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com
|
|
#25
February 11th, 2009, 12:22 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Microsoft Access 2007 Update fields
Thanks I think I have It.
"ruralguy via AccessMonster.com" wrote: Only delete the duplicate fields after you are comfortable with the fact that using a query with a join makes the fields available any time you want. Thel wrote: I have made a query with all the fields. Should I delete the dept desc and glcode from the employee table and then do a join on the fields. If they are not stored in the database employee how will I use them to print on reports? Have you created a query that joins the two tables on Dept yet? [quoted text clipped - 10 lines] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via http://www.accessmonster.com
|
|
#26
February 11th, 2009, 02:44 AM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Microsoft Access 2007 Update fields
Great! Thanks for posting back with your success.
Thel wrote: Thanks I think I have It. Only delete the duplicate fields after you are comfortable with the fact that using a query with a join makes the fields available any time you want. [quoted text clipped - 8 lines] Any help would be greatly appericated. Thelma -- RuralGuy (RG for short) aka Allan Bunch MS Access MVP - acXP WinXP Pro Please post back to this forum so all may benefit. Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...forms/200902/1
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
