By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
458,114 Members | 1,570 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 458,114 IT Pros & Developers. It's quick & easy.

Query summarize data

P: n/a
when i creat query from Query Wizard and select the fields from table
and click next it doesnt show me the option of Detail / Summary why is
it so?

i need to create query or say summarize data some thing like this

Date
status Total
May 12 2006 Completed 15
May 13 2006 InProgress
100
and so on

but my date field has time too its like 12/5/2006 8:32:15 AM
please help me acheive this

May 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
access baby wrote:
when i creat query from Query Wizard and select the fields from table
and click next it doesnt show me the option of Detail / Summary why is
it so?

i need to create query or say summarize data some thing like this

Date
status Total
May 12 2006 Completed 15
May 13 2006 InProgress
100
and so on

but my date field has time too its like 12/5/2006 8:32:15 AM
please help me acheive this
You can use DateSerial. Example in debug window
dtfld = Now()
? dateserial(Year(dtFld),Month(dtFld),Day(dtfld))
5/2/2007

Or use Format, which converts to a string
dtfld = Now
? format(dtfld,"mm/dd/yyyy")
05/02/2007

'or by converting the format back to a date field
? Cdate(format(dtfld,"mm/dd/yyyy"))
5/2/2007

05/02/2007

May 2 '07 #2

P: n/a
On May 2, 1:03 pm, salad <o...@vinegar.comwrote:
access baby wrote:
when i creat query from Query Wizard and select the fields from table
and click next it doesnt show me the option of Detail / Summary why is
it so?
i need to create query or say summarize data some thing like this
Date
status Total
May 12 2006 Completed 15
May 13 2006 InProgress
100
and so on
but my date field has time too its like 12/5/2006 8:32:15 AM
please help me acheive this

You can use DateSerial. Example in debug window
dtfld = Now()
? dateserial(Year(dtFld),Month(dtFld),Day(dtfld))
5/2/2007

Or use Format, which converts to a string
dtfld = Now
? format(dtfld,"mm/dd/yyyy")
05/02/2007

'or by converting the format back to a date field
? Cdate(format(dtfld,"mm/dd/yyyy"))
5/2/2007

05/02/2007- Hide quoted text -

- Show quoted text -
I need query to summarise data like But my date field is (5/2/2007
11:23:08AM)

Date Status Total
5/2/2007 Completed 20
5/5/2007 InProgress 100
5/6/2007 Deleted 50

May 3 '07 #3

P: n/a
bh*****@gmail.com wrote:
On May 2, 1:03 pm, salad <o...@vinegar.comwrote:
>>access baby wrote:
>>>when i creat query from Query Wizard and select the fields from table
and click next it doesnt show me the option of Detail / Summary why is
it so?
>>>i need to create query or say summarize data some thing like this
>>>Date
status Total
May 12 2006 Completed 15
May 13 2006 InProgress
100
and so on
>>>but my date field has time too its like 12/5/2006 8:32:15 AM
please help me acheive this

You can use DateSerial. Example in debug window
dtfld = Now()
? dateserial(Year(dtFld),Month(dtFld),Day(dtfld))
5/2/2007

Or use Format, which converts to a string
dtfld = Now
? format(dtfld,"mm/dd/yyyy")
05/02/2007

'or by converting the format back to a date field
? Cdate(format(dtfld,"mm/dd/yyyy"))
5/2/2007

05/02/2007- Hide quoted text -

- Show quoted text -


I need query to summarise data like But my date field is (5/2/2007
11:23:08AM)

Date Status Total
5/2/2007 Completed 20
5/5/2007 InProgress 100
5/6/2007 Deleted 50
And?

Are you the OP (original poster)?

If so, do you know how to do this...click on query tab/click new/Design
and add a table or two to the query? If so, do you know how to drag the
fields from the table to the colums? Do you know how to filter records
within a date range? (see Between in help). Do you know how to create
a calculated column?
Ten:10
will create a column with ten as the heading and a value of 10. You do
the same thing for formatting the date.

Do you need somebody to contact you personally and provide some assistance?

May 3 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.