A alexogir New member Local time Today, 08:37 Joined Jul 21, 2005 Messages 8 Jul 27, 2005 #1 I have a query that appends records to a table with a constant numer of fields. so sometimes I have fields with no data. is there any way to create query which selects only fields with data. thanks in advance
I have a query that appends records to a table with a constant numer of fields. so sometimes I have fields with no data. is there any way to create query which selects only fields with data. thanks in advance
RuralGuy AWF VIP Local time Today, 08:37 Joined Jul 2, 2005 Messages 13,819 Jul 28, 2005 #2 Where [FieldName] & "" <> ""
