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

J

jsccorps

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
 
S

Steve Schapel

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.
 
J

jsccorps

Steve

Thanks. I meant to post this in the report section (format will be used in
reports).
 
J

John Vinson

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]
 
J

jsccorps

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?
 
J

John Vinson

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]
 
J

jsccorps

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
 
J

John Vinson

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]
 
Top