Missing Values in a Query

[DeutchBose]

I have a table that's something like this:


Month|Field2|Field3
Jan|25|35
(Null)|26|44
(Null)|28|88
Feb|38|52
(Null)|33|22
Mar|22|11
(Null)|12|12

How would I automatically fill in the null values in the first column (i.e. rows two and three are jan, row 5 is feb, etc.)

 

[Norie]

Is there any way to determine which month to use for each record?

By the way where did you get the data?

 

[DeutchBose]

Unfortunately, there is no way to determine the month from the data...the data is imported from a spreadsheet

 

[Norie]

I think you need to goto the spreadsheet and insert the missing months.