The hide duplicates does not work in my report

[Guest]

I have a report set up to print out a work schedule calendar style,
Everything prints in the format I want expect the dates fields keep
displaying for every line in that day
even though I have the display duplicates turned off. I am not using any
grouping as the file is set up with each days entries on a seperate record.
If I try to set any groups the print out is incorrect, any suggestions or am
I trying to do something that can not be done?

 

[Allen Browne]

Any chance that the date/time field contains time values as well as the
date?

You may not see the times (e.g. if the Format is Short Date), but they would
be enough for Access to not consider the values as duplicates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...

 

[Guest]

It is a short date but I have the format set to dd for this as all I need is
the day number

 

[Allen Browne]

The determination of "duplicate" will be based on the values in the field,
not on the display format.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message

 

[Guest]

Please forgive me Allan I am new to the use of access and I can not afford to
take any of the courses that are offered, especially since there is none or
no one to teach them in this area.
So you got me, I do not know how to tell if i just have the date alone or
the date and time.
If I include a group in my report setup the date display is ok but it louses
up the report, in that it prints the groups on different pages, not what I
want! I have tried every way I can think of in setting the groupings, all
with the unsatisfactory results.
Thanks for your patience.

 

[Allen Browne]

Open your table in design view.
Select the date/time field.
In the lower pane, delete anything beside the Format property.
Save.
Open the table so you can see the data.
Is there a time as well as a date showing now in this field?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps.org.

message

 

[Guest]

Okay, Allen I did as you directed
There is no time showing in table when I view it.
I did not have any formatting set for displaying the date ti start with
The only thing I had was an input mask in the from of 00/00/00:0:
for extra short date, and none was defined in the report either
I am including the description of the table as outputted by the documenter
Columns
Name Type Size
entry_no Long Integer 4
Client Text 25
ScheduleName Text 15
Day Date/Time 8
DayName Text 12
Shift Text 12
Security Officer Text 12
I do not know if will mean anything to you, but at this point I'll try just
that.
Once again thanks for trying. Roger

 

[Allen Browne]

Okay, you have verified that the values are just dates, and therefore the
hide duplicates should work.

The field named "Day" could be an issue, since there is a VBA function by
that name. You would try renaming the field, and then changing the query the
report is based on, and the name of the control on the report, and its
ControlSource property. If you do that, make sure that the Name AutoCorrect
boxes first, under Tools | Options | General.

Beyond that, I'm not sure why Access would not be respecting the Hide
Duplicates property of the text box. Presumably you are at least sorting by
this field, so that the subsequent records will contain the duplicates.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps.org.

message

 

[Guest]

Okay Allan I'll go in and change the field name as you suggest.
And no I am not doing any sort. The file is in the order that I want already.
I am also not using a query at present but I am collecting information from
the help files to help me understand about setting up one. This SQL is like a
foriegn language to me, I understand just enough to get myself in trouble,
but not enough to get out of it once I get into it.

I have however set up various groups and sorts and all it does is make a
real mess of the way I want the data displayed, but it does elimate to
duplicate displaying of the dates when I set up a group on just the day the
problem is the columns will no longer display down for the entries for that
date the go across and repeat for the next date, instead it continues on down
that column on the page.I wil not be reading my e-mail for the next few days
as I will be away.
Once again thanks for trying: Roger

 

[Guest]

Okay Allan I'll go in and change the field name as you suggest.
And no I am not doing any sort. The file is in the order that I want already.
I am also not using a query at present but I am collecting information from
the help files to help me understand about setting up one. This SQL is like a
foriegn language to me, I understand just enough to get myself in trouble,
but not enough to get out of it once I get into it.

I have however set up various groups and sorts and all it does is make a
real mess of the way I want the data displayed, but it does elimate to
duplicate displaying of the dates when I set up a group on just the day the
problem is the columns will no longer display down for the entries for that
date the go across and repeat for the next date, instead it continues on down
that column on the page.I wil not be reading my e-mail for the next few days
as I will be away.
Once again thanks for trying: Roger

Okay Allen I'm back
Just want to say thanks for all your suggestions they did not completely
answers my original question however by following them I've been able to get
the report to display the way I want it to. I had to add a field to do it.
Now I working on dressing it up with some boxes around the data I'll let you
know how I make out if you wish.
Once again thanks, Bye for now