Recent content by Malik1969

Hi SynapseVampire, I understand your diappointment and I feel information provided earlier was not sufficient to propose any solution. Firs of all, this is my Fields/ data: Table.Cards SERIAL DATE (Date/ time field) CLI (Caller Line Identification) DESTINATION (Telephone number dialed)...

Hi SynapseVampire, Thanks for the tip. However I want to go further by giving following presentation: (Using Cross TAB if possible) Date Cards Expired Card in Use BREAKAGE 01/12/04 251 658 $25 02/12/04 362 363 $12$ ... ... ... BEAKAGE is my...

Hi All, I have a report where I have to describe how many prepaid calling cards has been expired (30 days to count after first use). In my Database I have card SERIAL number and other fields like DATE, AMOUNT, SALE etc. This means I have first to loop on each SERIAL, then check 1st day (min...

Waiting for your suggestion. Thanks.

Thanks and it is okay now. I want to go one step further, perhaps you can get me good idea. As I wish to represent Vendors with their Codes instead of their real names; so COMPAQ becomes "1" HP becomes "2" NEC becomes "3" IBM becomes "4" Finally report...

Dear dgillz, Thanks for your solution. Perhaps I did not follow correctly. I have an access table "ITEMS" in following manner: ID Item Vendor Price 1 Monitors IBM $60 2 Monitors NEC $50 3 Monitors HP $40 4 Monitors COMPAQ $30 5 Mouse...

Thanks for the quick answer. I understand that it is very easy the way you explain. But I want to display the data in cross-tab format, e.g. Monitors $60* $50 $40 $30 Mouses $2 $1.8 $1 $0.5 I tried cross-tab but in summarised field I have default option of showing min. value, while...

Hello CR Gurus, I am beginner to CR 9.0. I have table of items belong to different vendors with different prices. I want make a list based on following pattern: ITEMS VENDORS Monitors IBM($60*) NEC($50) DELL($40) COMPAQ($30) Mouses DELL($2) IBM($1.8) COMPAQ($1) NEC($0.5) * Vedors...