Recent content by satwah

Thanks Pat for explanation & good advice. I will take care of it in next build. for the time being Minty response has resolved my issue to move forward.

Thanks Minty - I am sorted now.

Thanks Minty I have incorporated the code you have suggested but it is still bringing record set date as mm/dd/yyyy. For Example if I pass the parameters Me.txt_DtTi as 01/08/2017 Me.txtDays as 0 So dStartDate gets value as 31/07/2017 and dEndDate gets values as 01/08/2017 and sSql =...

Thanks Mandy for the advise on readability of code, I will fix that. I am very new to Access to learning couple of things here. On Date format suggestion & link you have sent - I have change the select query to this but it is bringing no record now. I think I am still using Format function...

Hi there I am creating a record set based on users input of Dates. it is picking up more than the required data. It appears the problem of date format i.e. mm/dd/yyyy where I need to pick up in dd/mm/yyyy . I have applied Format() funtion but still it is not working. can someone help please...

Thanks - I go around it by splitting my row data in two rows. thanks for help;

Thank you Minty for correcting my Data in table. I ran your suggested query on Form with multiple scenarios. It worked fine for all of them expect "Winter" "Night " times. for example 01/11/2017 02:00:00 am should give me one row but it brings back no row. I can't see anything wrong in query.

Thanks Minty & Arnelgp. I am bit slow in picking up this access, so please excuse me for that... My Data or query has nothing to do with actual timeslot of the day i.e. to find out is it summer, day time or Winter ,evening time. In my table or data I have fix date & fix time period ( hence...

Okay - I am going to break my data as you have suggested in Table and will revert back with my findings.

Exact Data is my table is Summer Day 26/03/2017 28/10/2017 09:00:00 00:00:00 Summer Night 26/03/2017 28/10/2017 08:59:59 00:00:01 Winter Day 29/10/2017 25/03/2018 08:00:00 23:00:00 Winter Night 29/10/2017 25/03/2018 23:00:01 07:59:59

Yes Minty , I had it earlier and then changed it. Now seeing your reply I changed it again exactly you have suggested above. Please note that all field (Season_St_Dt, Season_Fi_Dt Season ,StartTime and EndTime) are DateTime type. Query I have wrote is PARAMETERS [var_TimeSlot] DateTime...

Thanks But Requirement for timeslot ( day or night) is fixed for season ( Winter & summer) which is determined by date So if User enter a date & time then I need to find it falls in which season and then check if time falls between "Day " or "Night" Please point me how to achieve this.

I have check that as well. If Parameter is 17/08/2017 11:11:11, this should return me one row with DLAF_Season as "Summer" and DLAF_Time_slot = "Day" But this is returning me as two rows for both Day & Night time slots as Date condition is true for both of them. My Data in the time is like...

Thanks Arnelgp - I have tried your query as mentioned above using CDbl function, but I still get the two row which indicate time is not taken into account. any other thoughts on this or Am I doing something wrong here.

Thanks Minty - I did try that also but when Time comes into picture, query doesn't work there.