Search results

Hi Bellah, Let's clarify There are 7 types of Employees; There are 4 paying methods; Can all 7 types of Employees be paid by the 4 paying methods or let's say Employee types 1,2 and 3 get paid by method 1, Employee type 4 and 5 get paid by method 3 etc? So far i'm thinking that you need a...

Thank you, Pat, Had a feeling that this would be the answer. Thanks for taking the time to answer. Dan

Hi everybody, Amongst many other things i would like to be able to see which teams in our company have access to which database. We currently use up to seven!!! different Databases which makes for tremendous fun...just kidding. Since every Team has access to more than one Database andevery...

Thank you so much FiFo and Pat, i got it sorted now... I am in the process of creating some forms now and then when i have decided on exactly what information i will need to collect, i will actually begin to work on the tracing application part of my db. Wish me luck... Thank you so much, Daniel

Hi Pat, Sorry about this, but i can't get the update query to work, I'm not sure where to join the tables and what to update to? I'm very grateful for your help, you are helping everywhere on here and i feel quite guilty taking up your time. I'd like to let you know that i am trying to get...

Thank you both for taking the time to answer my question, this helps tremendously, if i may just ask one more thing (for now...lol) Step 8 Recreate relationships and remember to enforce RI. i dont seem to be able to do this if not all the fields in the child tbl are filled in, let's say i've...

Hi everybody, i started 4 weeks ago to teach myself ms access in order to create a db that will enable me to store the results of a survey. whilst working on the db creating tbls for locations, divisions, subdivisions, teams etc etc i became aware of the capabilities of this beauty. not only...

Hi Sergeant, Do you want the fields in tblProblems to be memos? Are the problems actually described in the field? Dan

hi sergeant, i take it that tblPeople is not the same as tlbComputer, meaning that one user can access your db from different computers. maybe you could differentiate between types of trouble tickets (Problems), one type relates to the user, the other to the computer. have a tblProblemsPeople...

I thought that junction tables are the answer to this. in my db i have to combine teams with several consultants and even one consultant with several teams,i did all this with two tables, two fields each and one junction table with three fields. Is this wrong or bad practice? cheers, dan

Hello everybody, I'm also very new to access and database building, still doing masses of tutorials, but the answers on this thread reminded me of a question that i couldn't find the answer to as of yet. If i wanted to merge all the address fields either in a query or table or report, how could...