...+ ' days ' " _
& "+ truncate( ((datecreated + 7) - GetDate() )%24, 24) ) + ' hours ' " _
& "+ truncate( ((datecreated + 7) - GetDate() )%24 * 60, 60) ) + ' minutes ' " _
& "+ truncate( ((datecreated + 7) - GetDate() )%24 * 60 * 60, 60) ) + ' seconds remain' " _
& "FROM table_name"
Any help...