Search results

Thanks Galaxiom. I played around with your suggestion, and it worked!!! :)

I am creating this database for my friend and am at dead ends due to this silly issue thats causing me lot of trouble. I have a query, which sums up data from a table and when I try to present this data from the query in a chart form, access adds this 'Sum of' in the category title. Have spent...

Bingo! This worked!!! Thanks a ton, Beetle.

Hi All, I have a table in which there are 4 columns and I need to create a query which can only present me duplicate entries between 2 of these columns. Something like the below: Client # Self # Items Type 123 980 3 A 456 735 1 B 980...

Thanks. The suggestions seems to have worked but I have walked into another block now. Now I am able to pick out the records where the "received date" and "processed date" are the same. But this also gives me redundant information, for example, if there were 3 documents which were received and...

Hi, I have 2 columns in my table from which I want particular information: Column 1- Date "my company" received document Column 2- Date "my company" processed the document Could someone help me build a query on the number of documents which were received and processed on the same date? Would...

Hi All, I am currently preparing a database for the firm where I work and am just stuck at a point not knowing how to move forward. Of the many columns in the main table, I have one which lists the dates when new documents were received from the client. Now our firm then classifies these...