Search results

I know how to make a query I know how to Join tables I understand PK and FK. But despite the above I don't know what to do extactly..

:( Stuck. Don't know how to do this. if anybody is willing to point me in any direction I'd gladly accept the help. thanks

ah yes you're referring to ID on Main Table right ? yeah sorry bout that didn't mean to leave it there, it shouldn't. Don't worry about it though. So you say a query, how does the query link to the leave table ? ::confused:: :confused:

ok check the link again, i've fixed it. I've put NIN on the leave table and link it with relationship

Thanks rich, works !!! :cool:

Hey all another minor problem. I have a button, under the button there's a simple on click event, just some numbers to be added together (or multiply etc etc). Like A+B = C then /D. I just want the result, C to be placed in a box somewhere, any ideas ? thanking all

I've been trying to understand how to do this thing. Please check the link below http://www.nsb.gov.sc/db.zip I've placed my sample database there. Please note that my primary key is NIN cheers edit : sorry about the above, it's suppose to be 21 days not 27 like said thanks

namliam i cannot understand :( can you tell me how to go about doing this ? am no access expert, I can give you all the details you want though

I don't mind redesigning that's ok but I don't understand what you said above lol thanks :D

Hello all. new user here, not new to the computing world though :p I have made a small access database for work. Actually it's a Personnel management system. I have created tables/relationships and all is good. Here's the Problem. The db has a field name [Days] and one name [Taken]. This is...