I developed a pay roll [/B]application for my organization, I want to create a monthly report for the employees but I want it inform of querying the database(data file) to generate a report for two different months(like January and December)on a single report sheet, PLEASE HOW CAN I ACHIEVED THIS?
nfowomola2
0
Newbie Poster
Recommended Answers
Jump to PostYou create a query statement based on the dates you want to report on.
You must input that data using some type of date control--which would probably be best. Or you can have the user type in the date he wishes to query. But that leaves you open to …
Jump to PostYou use the same method as described before. But you have to use code to determine the first and last day of the required month.
Thirty days hath September,
April, June, and November;
All the rest have thirty-one,
Save February, with twenty-eight days clear,
And twenty-nine each leap …
All 5 Replies
hkdani
39
Posting Pro in Training
nfowomola2
0
Newbie Poster
hkdani
39
Posting Pro in Training
dspnhn
10
Junior Poster in Training
ChrisPadgham
113
Posting Whiz
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.