Search results for query: *

OK so i changed the column from a table reference to a list box and now the IIF runs the first true (yearly), but any of the others come back as the false more digging and now they all work EXCEPT a Bi_Weekly (i think) thank for everyones help!! i think i'll figure it out now :)

so, yes it returns -1 when i add that The Frequency table has two columns an ID and the periods (Weekly, Yearly, etc) all the spelling matches is it a problem to have the column and table named the same? i am changing it now just in case..

does it matter that the Frequency column is a drop chosen from another table?

the code looks correct does the math the way i want but still only produces the final value none of the others i modified the code slightly as i think there was one too many in there Public Function GetCostBack(ByRef strFreq As String, ByRef curCost As Currency) As Currency Dim curReturn As...

i did it doesn't go into how the code refences the table i will keep hunting for more in for on that thanks for your help :) OK so it puts in data, but still not correct..... i will keep looking into it

i haven't used VBA before, i am not sure where to put my column names strfreq is [frequency] correct? curcost = [cost] is that how i would replace them?

Cool now i will try to figure out how to use it! thanks!!

No, my typing is poor but the IIF matches the table with Capitals and _ i thought of that too :) if this helps when i put it in my table it just produces the cost when i put it in my query it gives an #error

Hello i am hoping someone can chime in i am purely just building this budget database for fun, but i want to figure it out dammit! i have two columns on the same table [Cost] and [Frequency] one is my cost the other is how often i pay. it is a dropdown from another table that contains: Weekly...