Search results

I am trying to tell this query to get the wkending of the date (timeInDate). My query run but returns no data. Can anyone be kind enough to look at the red part?

~Nice thread :) Bumping this up, as i'll need it soon.

Hi softboss, can you give me up this link again? I am working on something similar and need ideas. Also, how do i get the sample that ships with access?

I don't know what i'd be without you all You are all appreciated. the absolute best!

Not at all. the switch wasn't hard to put together ([logic],[value],[logic2],[value2]....). Took me about 8minutes in this example. But the nested IIF is a far cry away from that. You had to worry about nesting it properly and driving urself crazy. I had spent 2 fustrating working days on it, so...

:eek: wow! this is amazing! Here's all i have now :eek: =[R1] & ("-" + [requestDetails]) & ( " / " + [R2]) & ("-" + [requestDetails2]) This is great cos i had to use that code in 3 summary forms, i have gone around changing them already! Thank you so much!!! :cool: lovely!

Thanks ejstefl, I have practised it :D =Switch((IsNull([R2]) And IsNull([requestDetails2]) And IsNull([requestDetails])),[R1], (IsNull([R2]) And IsNull([requestDetails2]) And Not IsNull([requestDetails])),([R1] & ("-"+[requestDetails])), (Not IsNull([R2]) And IsNull([requestDetails2]) And Not...

lol..u welcome

Hmn..interesting! Didn't know that. I'll incorporate that into my code. Thank you ejstefl :D I have learned alot today! thanks dear

Ladies and gentlemen: Allow me to honor the Switch function My code below wasn't hard to put together at all...and it works perfectly. Nested IIf can perish!!, I found a new friend :D Banana, i can never thank you enough!! and John. Brian, thanks alot. =Switch((IsNull([R2]) And...

Ahh *sighs thanks banana :) that switch looks good, i'll go try it. My head is really spinning for real, i just went ballistic with curses #$%%$%# while pointing at my monitor 5minutes ago and my coworkers had to come check if i was okay...i hope i get this to work soonest or access will...

Now i get error: wrong number of argument with this. can anyone help? :( =IIf(IsNull([requestDetails]) And IsNull([requestDetails2])),(IIf(IsNull([R2]),[R1],([R1] & " / " & [R2])),(IIf(IsNull([requestDetails2]),([R1] & "-" & [requestDetails] & " / " & [R2]),([R1] & "-" & [requestDetails] & " /...

Thanks John and Brian. Yes i can have R2 without a requestDetails2, and in that case, i'd like to exclude the leading "-". I will go try what you have suggested above...

Women CAN be Pedophiles!!!

Hello friends, I have a form that displays a summary of my records (from my lovely work request database). A textbox named txtRequest should display a concantenation of the workrequestType based on an IIF statement in this matter. The fields in my table are: [R1] meaning primary request ...

okay .......:)

mean! see how u painted the code red! lol :p okay, i checked my date field, and i made ur edits as suggested here's what i have now, works like charm :D Dim dateIDX As Date Dim rs As Recordset Set recDates = CurrentDb.OpenRecordset("tblAbsence", dbOpenDynaset) For dateIDX =...

Hi David and Bodisathva: You have both been very helpful. and thanks for the quick response!! Here's what i have now but i get "runtime error 13. type mismatch" do you guys have any idea? Dim dateIDX As Date Dim recDates As Recordset Dim db As Database Set recDates =...

lol @ another cheque :D

I have looked high and low over the internet for a way to do this, but can't seem to find any. I have a form with 2comboboxes (popup calender) that takes a vacation date range (fromDate and toDate) for each employee (peopleId). This form is bound to a table (tblAbsense) with fields as peopleId...