Recent content by xyz321

  1. X

    Help with creating graph with overlapping dates

    Hi I am trying to create a graph from a set of values i have. I cant post attachments so i will try to write here as clearly as i can. I have three columns: A, B and C. A and B have Start and Finish dates respectively. In column C i have total expenditure against these dates. I want to...
  2. X

    Find duplicates with additional condition

    Thanks for ur suggestion. That can work but the problem is that if there are duplicate numbers assigned to two "approved" invoices then it will not pick up as the "approved" records will be eliminated from the results.
  3. X

    Find duplicates with additional condition

    Hi I am trying to find duplicates in a table of data but there is an additional condition to find the duplicates. I will try to explain what i am trying to do. The table has two columns. one is Company invoice no and second is client invoice no. Company invoice no is our company reference no...
  4. X

    Updating subform based on drop down

    Hye I have a very basic question which i hope someone can help me resolve. I have one huge table with details of supplier. As first step of creating a user interface i just want to create a normal form for users to see details. Table has details of suppliers i.e. name, contact no, email...
  5. X

    Get String function

    Thanks for your rpely. I am not trying to find the function but am trying to find what does this "Getstring" function do? do you have any ideas? Cheers
  6. X

    Get String function

    Hye I have an Access database in which one of the queries has following fields: Reference1:Getstring([Reference],1) and the second is Reference2:Getstring([Reference],2) I cant find any reference to Getstring function's use or functionality. Microsoft's website only says "Obsolete"...
  7. X

    Page Setup in Access Report

    Hye I have an access report which i have just modified to add fields. On the top left hand corner it gives me error that "Report Width is greater than page width". Microsoft help advises to change page setup. If i go to page setup, the page size is specified as "Letter". I tried changing to...
  8. X

    Exporting Access Reports into Excel

    Hye I need some help for exporting my access reports into excel. I have tried two options known to me, one to select "Export" from file menu and second is "Analyze data using Excel" from print preview toolbar. Both of these methods are unable to give me complete output. Some critical fields...
Back
Top Bottom