I can convert a yymmdd to (yymmdd - 1 day)
What I do is take the existing yymmdd string, convert it to a
mm/dd/yyyy date and subtract a day from it & then format it back into
yyymmdd.

But the expression is a monster beacuse I have to include the DateAdd()
for each part of the formatting.

Exp_date:
Right(DateAdd("d",-1,CDate(Mid([dupe_openTerms_1].[Exp_Date],3,2) & " "
& Right([dupe_openTerms_1].[Exp_Date],2) & " " &
Left([dupe_openTerms_1].[Exp_Date],2))),2) &
Left(DateAdd("d",-1,CDate(Mid([dupe_openTerms_1].[Exp_Date],3,2) & " "
& Right([dupe_openTerms_1].[Exp_Date],2) & " " &
Left([dupe_openTerms_1].[Exp_Date],2))),2) &
Mid(DateAdd("d",-1,CDate(Mid([dupe_openTerms_1].[Exp_Date],3,2) & " " &
Right([dupe_openTerms_1].[Exp_Date],2) & " " &
Left([dupe_openTerms_1].[Exp_Date],2))),4,2)

It would be prettier with a variable instead of having to repeat
DateAdd(). So I tried that. I created an expression Exp_Date1 in a
sperate non-displayed column that just did the DateAdd().  But when I
tried to reference [Exp_Date1] to format it, ACCESS prompted me for the
value. So that's why I use the big ugly.

Any ideas on slimming the expression down? Is there a way to define a
variable in ACCESS expressions?