Search results

ajetrumpet, It shows me all the records after the current date, but i needed the records between the current date and criteria date. I used between function to get it sorted and it seems to be ok. You really gave me the idea and it has been a great support from you. I really appreciate your...

Where will i write this SQL? Confused! I need to show this result in a report. please help! prajith

Chris, I have checked the querry you made and i made some changes. I mean instead of giving Enq Received date <Date()-10 we should give the criteria as 'Between Date()-10 AND Date(). Query1,2 and 3 shows the exact rows, but the final Query doesnt.As you said i beleive we shoul append this...

Trumpet, Thanks for your help. Here in my case there will be one search button on the form and when the user click on that it should show the result as per the criteria. I mean user will not enter any dates.that's the idea!. I have no idea about the 'Search Control' in your querry. Is it the...

Thanks Chris. Yes it is AND/OR. I mean i need records either from the first condition or from the other also. please advise. Thanks, prajith

Guys, Could you please help me to make a query with the below conditions from the attached test.mdb file? 1. Enq Received Date 10 days before the search date AND/OR 2. Technical Sub Date 4 weeks in advance of the search date AND/OR 3. Potential Date 4 weeks in advance of the search date The...

Share your knowledge to develop yourself If you can share your knoeledge , you are very much appreciated.. thats the price i can give you bro. Thanks,

where can i give this select querry Wyane, Thanks a lot for your reply. can u tell me where can i type this SQl? from the SQl View? if an employee exceeds more than 45 per week for a particular project for particular week, that can be overtime for that week for that employee. when we run the...

Hi Guys, I am new in MS access and i was told to generate an overtime report based on existing table which is made by my colleague 2 years ago.we are working 5 days @9 hrs per day OR 45 hours per WEEK.Through our timesheet filling application in access we are fill the details and it goes to a...