Hello Access Guru's..
I need your help on this quarry...
I have table with the below data
tbl_attend_log
ST_Name ST_Date ST_Attend
Tom 01/01/2014 1
Mat 01/01/2014...
I have a table named tbl_attend_log with the below data
ST_Name ST_Date ST_Attend
Tom 01/04/2014 1
Jim 01/04/2014 1
Harry 01/04/2014 1
Tom 02/04/2014 1
Jim...
Hello Guru's of Access....
I need your help on quarries....
I have create few option buttons in a form and assigned values. when each option button selected it will store a value in tbl.attend.log
Exp - Opt 1 button = 1 = OnDuty
Opt 2 Button = 2 = DutyTravel
Opt 3 Button...
SLDate Revenue
1/1/14 $200
2/1/14 $100
3/1/14 $50
4/1/14 $100
1/2/14 $200
2/2/14 $400
3/2/14 $100
4/2/14 $150
Okay sorry about it... I have a table call tbl.sales in this table I have columns SL_ID...
I have a table with daily sales figures as below. I need a quarry in access to display January and February sales in a text boxes
Date Revenue
1/1/14 $200
2/1/14 $100
3/1/14 $50
4/1/14 $100
1/2/14 $200
2/2/14 $400...