Printable View
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.
What do you think would NASA's respond be if someone ask (perhaps via email) how to build a space craft?Quote:
Originally Posted by chunk
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.
One table ;)
To select only records from one month you need to implement some condition/s (WHERE clause) into your SQL query.
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
First of all, what DB are you using?
I didn't say you have to be "well educated" - just educated.Quote:
Originally Posted by chunk
Logic however can be written in 1001 different ways but you still need to know something about it first.