Em Andamento

access SQL query - group by date range (after midnight problem)

Hi,(MDB file attached this time)

Attached is my MDB , need to populate a list of days with # of recordings

for each day grouped by day.

**Here is my problem:**

all data that was recorded after midnight is going to the next day:

i need it to go to the **previous** day .

I tried this:

**SELECT RecordedOnDate, COUNT(RecordedOnDate) AS RowCount, COUNT(SongID) AS [Total Amount]

FROM InfoTable

WHERE (RecordedOnDate > DateAdd('h', 5, #1/23/2011#)) AND (RecordedOnDate < DateAdd('h', 5, #1/24/2011#))

GROUP BY RecordedOnDate

ORDER BY RecordedOnDate DESC**

But cannot GROUP BY

Thanks

ELi

Habilidades: Administração de Bancos de Dados, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, SQL, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: sql group midnight date, select group, range query, access group, sql query, eli, data query, access sql, access order, sql mdb, sql select order, sql select, sql problem, access sql query, sql query access, time range, day php date, mdb query, query mdb, date days php, access mdb file, group time access, access group time, php days date, need sql query

Acerca do Empregador:
( 10 comentários ) Raanana, Israel

ID do Projeto: #3053407

Premiar a:

awais9981

See private message.

$1 USD em 1 dia
(1 Comentário)
0.0

11 freelancers estão ofertando em média $8 para este trabalho

talkwaqar

See private message.

$8.5 USD em 1 dia
(33 Comentários)
5.2
Clucas

See private message.

$8.5 USD em 1 dia
(41 Comentários)
4.7
alexitkin

See private message.

$8.5 USD em 1 dia
(28 Comentários)
4.6
malikirfan28

See private message.

$6.8 USD em 1 dia
(17 Comentários)
4.6
CrazyFramework

See private message.

$8.5 USD em 1 dia
(8 Comentários)
4.5
yubor

See private message.

$8.5 USD em 1 dia
(39 Comentários)
4.5
wesolvevw

See private message.

$8.5 USD em 1 dia
(49 Comentários)
4.4
bestflancer

See private message.

$8.5 USD em 1 dia
(11 Comentários)
4.1
shouket

See private message.

$8.5 USD em 1 dia
(10 Comentários)
2.9
iucoder

See private message.

$7.65 USD em 1 dia
(2 Comentários)
0.0