skip a line at a change of date

  • Thread starter Thread starter Nick
  • Start date Start date
N

Nick

Hello,

I have a form that is used in data sheet view. Is there any possible way to
skip one row at a change of date in the data sheet view and not the actual
data base.
 
Nick

Change of date ... today's date or the date in the row?

Remember that a form, even a data sheet, is "looking at" the data in the
database (unless, of course, your form is not bound to the data in any way,
in which case, why would you be using the data sheet view?).

"skip a row" implies that there's some order.

If you'll provide a more specific description of your situation, folks here
may be able to offer more specific suggestions...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Sorry about that I'm fairly new to access and I'm teaching myself as I go.

I have a column that a date is enter (MM/DD/YYYY). I would like to skip a
row at the change of the date that the person inputs. To make it easy for
the person processing the data to see the different days easier.

ex.
Date
04/01/2009
(blank row)
04/02/2009
 
Hi Nick,

The simplest way maybe to add a Grouping Sorting field of TheNameOf
YourDateField. Add a group footer for that and just leave a space open in
the group footer. That will leave a line space between dates.

Regards

Kevin
 
KC-Mass,

I'm not sure what you mean. I have a macro that filters on open. Is that
what you mean?

Jeff,

I'm using this data base for returns and there is two type Tags and RMA's.
The person going through them only needs to see one type at a time. She needs
to complete the older dated ones first, which she then update a true/false
field in the form and then it wont show up when she opens it again because of
the filter I have applied on open.
 
Nick

I'm having trouble visualizing what you have before you.

It would help me if I understood a bit more about your underlying data.

It might help others if you described a bit more about how you have defined
your form.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
here is the headers i see:

Complete Date Tag# RMA# (couple other columns)
04/01/2009
04/01/2009

04/02/2009
04/02/2009

I have three forms. One person enters data in form view in one (date, tag#,
rma#, ect. . .). The other two forms are filtered, with a macro on open, to
just show the information from items with just Tag# and the other to show
just from RMA#'s. The 2nd two forms are used in data sheet form, and I want
to skip one row at a change in date, so each day is separated but on the same
sheet, like I have above.

I hope this helps better, sorry for the lack of info on my part.
 
Nick

Hopefully someone here in the newsgroups can offer ideas, based on your
descriptions of your forms.

I don't feel I understand your underlying data (i.e., table structure) well
enough to offer assistance.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top