want comments to show 1x not 2x's

  • Thread starter Thread starter nydia
  • Start date Start date
N

nydia

i have a dba that keeps track of clients entering and
leaving the program. tbl1 has name, address, phone, and a
comments section. tbl2 has start date, enddate. PC's are
great, but we still want some type of hard copy, so i
created a cmd button that on click will open a report,
which consist of name, address, phone, entry date and
comments.

we have some clients that may leave the program and come
back months later,so if a client leaves and comes back
there are 2 entry dates, which is fine, the problem is
when there is 2 entry dates, it will show the comments
section 2. i only want it to show 1 time, as it is a memo
field, so the user will just keep adding to it. how do i
accmplish this task?
 
Something is wrong in the design of your report! Base the main report on tbl1
and a subreport on tbl2 and comments will only come out once. When a client
leaves and comes back, you shouldn't reenter his info in tbl1 just the dates in
tbl2.
 
Back
Top