Recent content by sgadow

nevermind I figured it out.. the date was set for january 5th i thought it was the 1st of may.. so i swapped it and it works fine now :) you guys are amazing thank you so so much

ok must have had something messed up now it works :) i am so sorry i probably frustrated you guys to all hell.. ok well it kind of works.. Query1 TargetHours student_number grad_year 208.333333333333 1320002 2014 400 1270009 2012 308.333333333333 1270012 2013...

that was a typo when i was retyping it.. it's not in the query

ok got it have an error though Wrong number of arguments used with function in query expression 'HourTotalProgress(student_info.grad_year, studenthourtotals.hours_req], NumberofMonths)'Where does NumberofMonths come from? (if i replace that with 48 i still get the same error btw) SELECT...

Ok.. using your first code and changing the 36 to 48.. I think i also need to reference the table/query location of the parameters don't i like below?.. just adding the x.y don't work.. my ( are off now i think.... also what would i put in the query field? Function HourTotalProgress(ByRef...

correct.. so for example the school year for my purposes runs from june to may so a freshman in june would be on month 1 so for example (had to change my math from my original code because it didn't work correctly) ElseIf (student_info.[grad_year] - Year(Now()) = 3) And (Month(Now()) = 1)...

I see where you are going with this I just can't seem to put it with what I have.. like with the case statement.. at any rate i think i confused you by not putting the full code.. so maybe this will help... Option Compare Database Public Function hourtotalprogress() If (student_info.[grad_year]...

ok well basically.. i have a query studenthourtotals that I would like to populate a field datehoursneeded based on the if then else statement i showed.. what this statement does is takes a kids graduation year from an existing table - the current year to give me a 0-3 (the rest of the...

I am nto so hot at VBA so this is probably a mess.. but what I am attempting to do is use this function to populate a field in a query.. but i get the runtime error 424 Object Required.. there are more elseif statements but they are all the same format and context.. any ideas? Public Function...