Ok, here is what I figured out with the keywords "cross tab query" sent by Mr B. that reminded me of the word transpose. when I reread the help files on the issue this is what I came up with. data was in qr_res. create a table with all dates (daily) in range (not very elegant) (result...