Recent content by Geert

  1. G

    Creating budgets from already exisiting entries?

    Hi Sugar, I am intrested in your example, but i can not download it. Hoping that you can solve this. Regards, Geert
  2. G

    Need help Normalizing a pre-existing db

    Hi Hibbi, Perhaps you can buy proffesional software as Microsoft Project. This system is much better and allows more. Succes Geert
  3. G

    import unnormalized .txt coloms to row

    Hi Pat, Thanks for your answer. My problem is solved. Thank you very much, Regards Geert :) (I am very happy with this forum)
  4. G

    import unnormalized .txt coloms to row

    Hello, I import a unnormalized .txt file. I want to change the colomn in table 1(only year) in rows. My database will have then the right structure. i can not change the import file. I need to change the structure. tabel 1: Activa-id 2005 2006 2007 2008 2009 2010 1 850 935 1029 1132 1245...
  5. G

    Union All

    Hello, I want to see the numbers for a particular @Year, with totals for each Month, Account and Department. The following tables: Budget: (Year, Month, Account, Dept) (PK), Amount Commitments: CommitmentID (Identity, PK), Year, Month, Account, Dept, Amount Actuals: ActualID (Identity, PK)...
  6. G

    HasData method

    Hoi Olivia, Thanks for your examples. I will study the structure. I have also the fields: Cost-unit, account and periode. Perhaps i must do normalition my database. Keep me on information. Regards, Geert
  7. G

    HasData method

    Hello Olivia, Thanks for your reaction. I am also a newby in Access. I am looking for a example with the next fields: Actual Budget diffActualBudget Account Cost I have difficulties with the relationships en amounts of zere. I will be appreciate 1f you have a example for me. I will see if...
  8. G

    HasData method

    Hello, I convert your example to version 97. I have also a budget en actuals and i want to see the sum between the budget and actual per month. I worked always with Excel but now i have too much rules. Your example is great for me. I hope that you get a good example. Regards, Geert (From...
  9. G

    HasData method

    Hi, Here the version Windows 2000. Regrards, Geert
  10. G

    HasData method

    Hello, Good question. I have the same problems. My e-mail is geert678@hotmail.com if you have it solved, please send me your good example, Regards, Geert (From Belgium)
Back
Top Bottom