Delete report data, NOT report

[Cher]

My sales reps report to me each week on a form I created
for them. The form puts the data into a report and I've
used a delete query so that they don't keep adding to the
form. What I would really prefer to do is let them keep
the data, but remove it from the form so that a new form
is sent each time. The Delete option removes the form
completely - not a good option!

Can someone help?

TIA,
Cher

 

[Wayne Morgan]

Huh?

Data should be stored in tables, not forms or reports. Forms and reports are then used to
access and display and/or manipulate the data. What exactly are you trying to do? Have you
tried a query between the table and form or report to limit what data you see (perhaps
limit by date)?