hello,
i need your help.
i have a tblwarranty.In tblwarranty i have field monthOfWarranty(numbers), field startdate(date/time) and field endDate(date/time).
i try to using update query.i add tblwarranty
in QBE,
field:endDate
table:warranty
update:[warranty].[monthOfWarranty]+[warranty].[startdate]

the result just calculate a "dd" but i need it's calculate a "mm"

do you know how to do that? please tell me !

cheer,
yus



[This message has been edited by yus (edited 03-26-2002).]

DateAdd("m",[monthOfWarranty],[startdate])

thank for your help, rich.
but i have a new problem.in a same table a had a field WarrantyBalance(day).
how can i get a balance days from field startDate to field endDate automatic running for day by day

cheer
yus

[This message has been edited by yus (edited 03-28-2002).]