Search results

  1. Z

    create different projects in Access

    Hi, i want the user to be able to create different projects in Access and also would like the user to have the option to browse all the existing projects and select/edit or even delete any project he/she would like. Any idea or sample databases would be appreciated. thanks
  2. Z

    export file and save it under your local drive

    any help will be appreciated.
  3. Z

    export file and save it under your local drive

    Hi, Is there a way to do this: 1) when exporting the file, save the file with the same name as the items in the selected item list box and save all the files under C:\ for instance, if the "Beverage" is exported then i want to save the file as "Beverage.xls". If "Seafood" is exported then i want...
  4. Z

    check if fields exist in a table then add new field

    thanks Banana, at least you are giving a hint. i appreciate that.
  5. Z

    check if fields exist in a table then add new field

    You are just keep asking the same thing over and over. i came this forum to get help and clearly i am not an expert of coding or the techniques you are talking about
  6. Z

    check if fields exist in a table then add new field

    I have answered all your question, so can someone help me here? Or please tell me if what i am trying to accomplish is not possible. thanks
  7. Z

    check if fields exist in a table then add new field

    The user selects the following from a drop down box store name store location Revenue Year (the years are dynamic and they could be either be 2004, 2005, 2006, 2007.... and so on) The user always selects start date and end date for the revenue. Once the user makes his/her own selection, then...
  8. Z

    check if fields exist in a table then add new field

    the fields are dynamic and they are based on user selection. The user may select field1 and field2 today but tomorow he/she may select field9 and field10 so that is why i am not using a query. I would not know which fields will be in the table because different users select different fields...
  9. Z

    check if fields exist in a table then add new field

    thanks for the quick response. The new field will have the result of calculation. For instance, if the 2 fields found then i want to substract field1 minus field2. That is all what i need. I hope you can help me with this as i was trying to figure out the last 3 days. many thanks.
  10. Z

    check if fields exist in a table then add new field

    Hi, I have a table and i would like to check always 2 fields if they exist. If the 2 fields exist then i want to add a new field. How can i do this? here is the pseudocode: check if field1 and field2 exist in MyTable if field1 and field2 exist then add new field else exit
  11. Z

    Check if specific column name exist in a table

    I am not the expert but i normalized now but i am not sure how to calculate it. For instance, 2006-2007 and 2007-2008 but please keep in mind the years are dynamic. Pls. see attached how i normalized. I really appreciate your help. thanks.
  12. Z

    Check if specific column name exist in a table

    Banana, Thanks for your response. Just to clarify, i have a table that has several columns and in this table i could have the following columns : 2006, 2007, 2008, 2009 and etc. So the table is generated per user's selection meaning the user can select to include in the table the revenues for...
  13. Z

    Check if specific column name exist in a table

    Can someone help me here? thanks
  14. Z

    Check if specific column name exist in a table

    Hi There, I have a table that table contain few columns but i am looking for specific columns and if found those specific columns; i want to perform simple calculation. Here is the pseudocode for what i am trying to do: Check if column names exist first (in this case the spefic column are...
  15. Z

    Insert new columns and calculate the percentage for Year over Year

    David, The years are dynamic meaning the MainTable may contain the years like 2009, 2010, 2011 etc. And i want always to calculate the year over year percentage like in this case (20010-2009)/2009 and so on. So this is my main problem; the years are not fixed years they can change and they...
  16. Z

    Annualize Rolling data

    Thanks David. There is another post i just posted today but so far no one seems to help. If you help me with this number then we can look at some of these numbers. many thanks. Here is the post link: http://www.access-programmers.co.uk/forums/showthread.php?t=177796
  17. Z

    Annualize Rolling data

    Thanks, it works greate
  18. Z

    Insert new columns and calculate the percentage for Year over Year

    Hi, I have the followings in a table: FAC_NAME 2006 2007 2008 MAL 300 200 600 GES 200 500 400 Pls. note the Years are dynamic, meaning it can start from 2005 or 2006 and can go up to 2011 or 2013 etc. So, what I want to do here is...
  19. Z

    Annualize Rolling data

    Hi, This is a huge project i am working on and i am stuck this part. I want to perform some calculation in order to get the ANNUAL NUMBERS FOR EACH FAC_CODE. For isntance, the FAC_CODE for FA255 has submitted a data for all 200701, 200702, 200703, 200704 and these are a Quarterly data. So what i...
  20. Z

    Check if values exist then insert new fields

    can you tell me how would l do that? thanks
Back
Top Bottom