how to extract data for selected month
please tell me what should be the logic of saving data in database for each months? should i save in one table or there is any other simple and good way to do this? if i save data in one table only then how will i get only selected month data while navigating Recordset MovePrevious, MoveNext, MoveFirst, MoveLast method. only selected month data should navigate on these button. please tell me the simplest way to do this. i need this solution urgently.
Re: how to extract data for selected month
Quote:
Originally Posted by chunk
please tell me what should be the logic of saving data in database for each months?..
What do you think would NASA's respond be if someone ask (perhaps via email) how to build a space craft?
Don't you think someone must get educated on the topic first?
In your case how can you even think about working with databases if you don't know what it is?
You need to get yourself one of these books ot at least visit our DB Develpment FAQ forum.
Sorry for being a bit harsh.
Re: how to extract data for selected month
One table ;)
To select only records from one month you need to implement some condition/s (WHERE clause) into your SQL query.
Re: how to extract data for selected month
Thanks RhinoBull for your reply and the useful link, but if some is well educated for any topic then why anyone will ask the question to others? i just want to know the logic. thank you for reply
Gavio,
i want to work with months because of Employees Salary. can you please make me more clear about database?
suppose i have these fields and pls tell me what field i need to add according to you for date or any other simple logic
Emp_ID
Emp_name
Emp_phone
Emp_Salary
Emp_month
Re: how to extract data for selected month
First of all, what DB are you using?
Re: how to extract data for selected month
Quote:
Originally Posted by chunk
... but if some is well educated for any topic then why anyone will ask the question to others?...
I didn't say you have to be "well educated" - just educated.
Logic however can be written in 1001 different ways but you still need to know something about it first.