Repeating data in Rows

[rama]

Hi
My access select query is having some fields which are "Date",
"JobNo", "Section", "JobDesc" etc.
The query works fine but what I wish to do is to group query results
datewise so that I can avoid
repeating date in each row. At present my query result looks like
this.

Date JobNo Section JobDesc
24/01/2009 1 2A X
24/01/2009 2 2A X
25/01/2009 3 2B X
25/01/2009 4 2A X

I wish to get the results like this.

Date JobNo Section JobDesc
24/01/2009 1 2A X
2 2A X
25/01/2009 3 2B X
4 2A X
Any help would be appreciated.

 

[John W. Vinson]

I wish to get the results like this.

Date JobNo Section JobDesc
24/01/2009 1 2A X
2 2A X
25/01/2009 3 2B X
4 2A X
Any help would be appreciated.

That's very easily done on a Report - which is what you should be using to
print data in any case - but would be quite difficult (and actually probably
undesirable) in a Query. Why do you feel that you need it?

 

[rama]

That's very easily done on a Report - which is what you should be using to
print data in any case - but would be quite difficult (and actually probably
undesirable) in a Query. Why do you feel that you need it?

Hello

Thank you very much for considering my message. Actually in my reports
I am having a date header to
display and print the data as you mentioned but someone else is using
such a query to put some more additional data in the fields
"JobDone", "Status" etc (which I didn't mention in the earlier post)
as my application is for multiple users. In that case such display
will be helpful.

 

[John W. Vinson]

Hello

Thank you very much for considering my message. Actually in my reports
I am having a date header to
display and print the data as you mentioned but someone else is using
such a query to put some more additional data in the fields
"JobDone", "Status" etc (which I didn't mention in the earlier post)
as my application is for multiple users. In that case such display
will be helpful.

Don't confuse data STORAGE with data PRESENTATION.

The blank in your example is not the same as a NULL or empty field. It's a
shorthand for 24/01/2009. It's actually a date; it's data that you simply
don't want visible - but it still needs to be there, in your query.

If users are viewing data in query datasheets, they should a) know what
they're doing and b) actually expect to see the data that's there.

If you want a presentation feature such as suppression of duplicates, use a
presentation tool - a Report.

 

[rama]

Don't confuse data STORAGE with data PRESENTATION.

The blank in your example is not the same as a NULL or empty field. It's a
shorthand for 24/01/2009. It's actually a date; it's data that you simply
don't want visible - but it still needs to be there, in your query.

If users are viewing data in query datasheets, they should a) know what
they're doing and b) actually expect to see the data that's there.

If you want a presentation feature such as suppression of duplicates, usea
presentation tool - a Report.
--

             John W. Vinson [MVP]- Hide quoted text -

- Show quoted text -

Hello
Thank you very much for the reply.