Updating a column that is not competely populated

[rHairing]

Hello,

I am new to this board. I have a report where one column is not fully populated while the rest of the columns are competely populated. For example, I have the first record in this column where it is populated(call this SAM) but then the next 3 entries which need to be populated with SAM as well are blank in this column. Next is MEG...same issue. How do I tell it where it is null in that column update it with SAM until it gets to the next populated entry, MEG and populate those and so on? Below is an example:

1 SAM 1 6 7 8
2 6 8 9 4
3 5 7 2 3
4 MEG 6 6 8 8
5 2 6 7 2
6 8 3 6 4

 

[fredk]

I am not sure I totaly understand your data structure. I am not sure what field 1,2,3,4,5,6 are - I would suggest going under the reports sorting and grouping and create grouping on the field name that holds sam and meagan - Select yes for group header (and footer if you want to total under Sam and Meg.

This is just to point you in a way that may work for you.

Good luck

Fred

 

[rHairing]

Hi Fred,

Thanks for the post. As I said I am new so I may not have asked the right question. The 1,2,3,4 simply represent the rows in the table.

Let me try asking from a different angle. How do I write a query that says if a record is null, update it with the previous record? That would work as well.

Thanks,

Sara

 

[PHV]

How can you ascertain the rows order ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244