Recent content by xyz321

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...

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.

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...

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...

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

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"...

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...

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...