how can i group the database by dates and by names

[RhazeMondragon]

i was have difficulties by retrieving records in the database, for example i want to get the sum of transaction by the date, group by people,,

[debasisdas]

Try to use GROUP BY in the SQL query.

Post your table structure for more details.

[9815402440]

hi
your sql query must look like this

select sum(column) from table group by Date, People

if this is not the solution then explain your problam in detial

regards
manpreet singh dhillon hoshiarpur

[daveftl]

i was have difficulties by retrieving records in the database, for example i want to get the sum of transaction by the date, group by people,,

try this sql:

SELECT SUM(transaction) FROM <table>, ORDER BY <table.date>;

for more detailed answer..please post ur DB structure . :)

[Killer42]

i was have difficulties by retrieving records in the database, for example i want to get the sum of transaction by the date, group by people,,

I recommend you ask in the Access forum, as the people there have lots of database experience.

[RhazeMondragon]

this is my databse.... is this correct???

"Select F_Empl_Code, Supply_Date, Sum(Supp_Total), Min(Supp_Balance) from Tbl_Supply_Transaction Where Supply_Date between '" & txtDate1.Text & "' and '" & txtDate2.Text & "' GROUP BY F_Empl_Code, Supply_Date

[Killer42]

this is my database...

My SQL syntax is a bit shaky. But what type of database is it? Access? SQL Server? Other? The different products do treat things slightly differently. In Access, date fields use hashes (#) as a delimiter, not quotes (').