First row has customer name, subsequent rows the name field is bla

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

Guest

For example, currently I have:

Name Sales
John Doe 5
John Doe 6
Mary Lee 8
Mary Lee 7

What I would like:

Name Sales
John Doe 5
6
Mary Lee 8
7
 
Jsccorps,

There is no way to do this in any useful way in a query... but then that
probably doesn't matter, because generally a query datasheet is not
really designed to be seen by users anyway. The result you are seeking
is very easy in a Report, if you base the report on the query... the
Name textbox has a Hide Duplicates property which can be set to Yes. As
far as I know, to get this result on a From you would need to use a subform.

If this doesn't help. maybe you can post back with some more details
about when, where, and why you want this effect.
 
Steve

Thanks. I meant to post this in the report section (format will be used in
reports).
 
For example, currently I have:

Name Sales
John Doe 5
John Doe 6
Mary Lee 8
Mary Lee 7

What I would like:

Name Sales
John Doe 5
6
Mary Lee 8
7
Click to expand...

This is easy to do in a Report - set the Hide Duplicates property of
the Name textbox to Yes.

It's much more difficult in a query or a Form. Users shouldn't be
looking at Query Datasheets in any case; if you really need this on a
Form, for onscreen viewing, post back and I'll see if I can come up
with something.

John W. Vinson[MVP]
 
I am using this for reports.

However, seems that Hide Duplicates work within the same type. I have a
report with different types and when a set Hide Duplicates the same name
appears in each type. How can I resolve this?
 
I am using this for reports.

However, seems that Hide Duplicates work within the same type. I have a
report with different types and when a set Hide Duplicates the same name
appears in each type. How can I resolve this?
Click to expand...

You've lost me. What do you mean by a "Type" in this context? What's
the Recordsource of the form? What are the control sources of the
textboxes that you're trying to hide?

John W. Vinson[MVP]
 
For example, I have the following table as recordsource:

Type Cname Amount
Sales Jay 8
Sales Jay 7
Sales Jay 9
Returns Jay -2
Returns Jay -8

The report uses the type field for grouping (set using the report wizard).
With Hide Duplicate Cname the report appears as (i hide the type
altogether):

Jay 8
7
9
Jay -2
-8

What I want is:

Jay 8
7
9
-2
-8
 
The report uses the type field for grouping (set using the report wizard).
With Hide Duplicate Cname the report appears as (i hide the type
altogether):

Jay 8
7
9
Jay -2
-8

What I want is:

Jay 8
7
9
-2
-8
Click to expand...

What happens if you base the Report on a Query which doesn't include
the Type at all, or has its Show checkbox unchecked?


John W. Vinson[MVP]
 
The type field is used in the report to group on sales and returns. For
example, I have the following table:

Type Cname Amount
Sales Jay 8
Sales Jay 7
Sales Jay 9
Sales Dan 2
Sales Dan 6
Sales Dan 7
Returns Jay -2
Returns Jay -8
Returns Dan -3
Returns Dan -4

Using the type field in the report (grouping on Sales and Returns) gives me:

Jay 8
7
9
Jay -2
-8
Dan 2
6
7
Dan -3
-4

What I want is:

Jay 8
7
9
-2
-8
Dan 2
6
7
-3
-4

The names, for sales and returns, only occur once.

(if this can't be done via a report setting/property, would it make sense
for me to run this by the access programming discussion group?)
 
(if this can't be done via a report setting/property, would it make sense
for me to run this by the access programming discussion group?)
Click to expand...

I'd suggest posting in the Reports newsgroup first - there are some
slick tricks you can do with the Format event, but I'm not enough of a
reports expert to say. I certainly can't think of a good way to do it
in a Query!

Good luck - I'll watch m.p.a.reports (which I normally don't
subscribe) to see, I'm curious!

Sorry I can't be of more help.

John W. Vinson[MVP]
 
Back
Top