Limiting output

E

Ernest Lai

I have a database which has 100's of entries. At the start of the database
i have some information like todays date. Expr10: Format(Date(),"yyyymmdd")

(dont ask me why its in that format, someone requested it)

However the date is repeated in every single row that i have data. eg. i
have 300 entries the date is repeated 300 times.

Is there any way to have the date displayed once in the first row only?

Any help is really appreciated and thanks in advance.
 
M

Mauricio Silva

Hi Ernest,

if you are talking about reports, you can turn on the property "Hide
Duplicates" and the value will appear only once.

Now, to do it on a form, you may need to use something else because this
option is not available. When I did it, I had a structure like group/sub
group, fortunately my subgroups were numbered, starting from 1 so, on the
form, I did a Conditional Formmating, every time the subgroup number were
<>1, foreground color = backgroup color. This option will slow your form
performance, but will do the trick.

Mauricio Silva
 
Top