Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by pumog

  1. pumog

    Updating date box in a form - possible?

    OK great you are right - couldn't find an appropriate course and wasn't sure what book to read! Thanks
  2. pumog

    Updating date box in a form - possible?

    Hi I managed to do what you said, but problem is that when I open the form it shows ALL the data (ie survival days for all the patients) rather than just for the particular patient whose record we are viewing. All the other tables are linked in by operation number so I've added the same kind...
  3. pumog

    Updating date box in a form - possible?

    Fantastic, done it!! One last question... it only works if I input a specific date, but my data base has hundreds of different patients in it with different operation dates, and will of course keep growing. How do I get the sum to refer to any date within "Operation Date" (which is...
  4. pumog

    Updating date box in a form - possible?

    Hi I worked out the 1st two suggestions which are fine, then I tried =DateDiff("d",25/9/3,Date()) just to see what happened, and I keep getting 37890... what am I doing wrong, please?! Thanks very much
  5. pumog

    Updating date box in a form - possible?

    Thank you very much for your help - I'm going to try it! I haven't much experience in putting commands in so I might be back..... thanks again
  6. pumog

    Updating date box in a form - possible?

    Hi I'm running a database at a hospital for research purposes about patients with a certain condition. I want to have a box which keeps a running total of how many days they have survived since operation. I haven't worked out how to do it all in Access but I can do it in Excel - or I could if...
See more

Part and Inventory Search

Back
Top