Michael Sync wrote: don't know why there are so many people like that.. they just post the question and if we ask them back, they never reply.. I figure I either made them feel really stupid or answered their inquiry. "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

You have to create Formula for the Fields.....The formula will be based on your criteria on which you want to display results or not.... Suppose you want nothing to show in Column1 if the Field1(to be shown in Column1) value is 0 then make a Formula.In Formula Editor under the "Suppress" Tab write the following Code.. If myTable.Field1='0' then true now if your query returns 0 in Field1 Column1 will be blank... But the thing to remember,though I am not very sure,is you probably cannot change the design of you report,I mean to say you cannot suppress Column1 with its Caption(if any) and other things....there will be a blank space... Tirtha Miles to go before I sleep

M A A Mehedi Hasan wrote: Bangladesh defeated India by 5 wickets in World Cup Cricket 2007. CONGRATS Bangladesh Tigers !!! :~ come on. wsu went to double overtime Later, JoeSox "Pleasure in the job puts perfection in the work." -Aristotle CPMCv1.0 ↔ humanaiproject.org ↔ Last.fm

You can always generate scripts to build the databases and then use WinMerge to compare the two. Rocky <>< Latest Code Blog Post: SQL Server Express Warnings & Tips Latest Tech Blog Post: Microsoft doing it again!

Perhaps, but I've learned to be cynical of 'look what I found' posts over the years. Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog

Edbert P wrote: Oh wait, it's just a joke, is it? Yep :). I figured most people would know what decaf means ;) Ryan "Punctuality is only a virtue for those who aren't smart enough to think of good excuses for being late" John Nichol "Point Of Impact"

Dear Guffa, Thanks for ur response. Actually I'm not interested in second solution (polling every x seconds). I want to develop a desktop program to process the data but I don't know how to call the program from database. Please help me regarding this. Mehedi Hasan