From: HarvestWind@comcast.net   
      
   Thanks Steve:   
      
   As I was writing the last note for the board, I realized that all I had to   
   do was use a cross tab query and that might "fix" the problem...rather than   
   moving the data to a different table...then querrying it... I tried   
   it...and, by golly, it worked... KISS has always escaped me (Keep it simple   
   stupid...) :0)...thanks for taking the time to reply.   
      
   JP   
   "Steve Gerrard"  wrote in message   
   news:Ga6dneCGotelNbXZnZ2dnUVZ_u-dnZ2d@comcast.com...   
   >   
   > "Joe-Paul"  wrote in message   
   > news:DKKdnSA9vdRB87XZnZ2dnUVZ_tudnZ2d@comcast.com...   
   >> Hi Ralph:   
   >>   
   >>   So I "append" the frist set of data from table one into table   
   >> two...then update table two with the info from an SQL getting the   
   >> corresponding data for the second part of the comparison.  ONce in the   
   >> second table, I use another SQL to bring the data into a datagrid.  But   
   >> when I do that, the first time the process runs, the second amount of   
   >> data does not show up in the grid... I refresh it, but that doesn't   
   >> change anything.  If put a "msgbox" in the procedures just before the   
   >> grid is loaded...all data shows...without the "msgbox"...the second half   
   >> of the data is dropped.   
   >>   
   >   
   > This is clearly a timing problem, which the msgbox "fixes" by putting in a   
   > big fat delay. It has something to do with the way you are using the grid,   
   > not with SQL or the database. Refreshing does not always mean the same   
   > thing as Requery, and sometimes just means the display is repainted. After   
   > you are done with all data modifications, be certain that you are   
   > re-running the query that pulls the data into the grid.   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)