prevent duplication in querie to report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H
I have a field name date. what I would like to do is to prevent duplication query - where it is group by I changed it to "First" (first of date request) and in the next field "Last" (last of Date request) I want a record show when there is a differnet date.
ie. "First" date 9/4/0
"Last" date 9/403 the

I have a record with two difference dat
i.e. "first" 9/24/0
"last" 10/24/0

how to prevent last from duplicating from first
 
Hi,


In the table design, make a index not allowing duplication of the date time
field (or make a compound index not allowing duplication of the couple
(group, dateTime) ).

By the way, use MIN and MAX, not FIRST neither LAST... they DO NOT MEAN
earliest neither latest, they just mean first/last seen by the engine
accordingly to the query plan the engine has decided to use... in other
words, they mean to take the values from a pseudo "random" record.



Hoping it may help,
Vanderghast, Access MVP


Bessie said:
Hi
I have a field name date. what I would like to do is to prevent
Click to expand...
duplication query - where it is group by I changed it to "First" (first of
date request) and in the next field "Last" (last of Date request) I want a
record show when there is a differnet date.
 
Back
Top