Search results

Whoops, never mind. I got it. Thank you very much. Now I will know how to handle null values also.

Pat, Ahhh, that was my mistake on my iif statement. I now understand master. I forgot to look for that syntax in the help file. On regards of a criteria in the query, is it possible that when the value is -1 to not display, and when the value is 0 to display that record?

Complex Query not working....Totally Lost now Ok, I'm totally lost now on how to create this in my Query. IIf(Date()<DateAdd("m",1,[DateAssesed]) And [DateVerified]=Null,Yes,No) I'm not sure how or where to put this. If someone can help me out on this, I'll apreciate it. Thank You.

I wanted to created a payment due date just for looks.

Is there a way to do a dateadd looping? Here's the situations. I have a date of 10/1/03 and want to create a query that will loop it according to current date. I know that if I was using dateadd("m", 2, #10/1/03#) will generate 11/1/03. So in my query it would show something like this...

Ok, I get this idea, but I don't think it will work properly. Cause, it does not show John doe monthly payment of $20 for October, November, December.

That's it! LOL! My head must of been in the wrong place when I was thinking this. Thank you very much.

I really hate being a n00bie at this and I must ask now that I so stuck. I know for any type of monthly payments, I will have to use a query to do this. But now i'm stuck on weather a datepart or datediff or maybe something outrageously different syntax to use to calculate this. I have...

ahhh...ok, thanks for the enlightenment. I understand now what it's purpose is.

ahhh...ok, thanks for the enlightenment. I understand now what it's purpose is.

Ok guys/gals, I'm just a newbie here and I'm trying to do some reading on union queries. It seems that if your trying to keep an on-hand balance of inventory that this is the most suggested. I tried doing multiple searches on anything that might relate to both these items but can't seem to...

Hey guys/gals, n00b here with just a quick question. I currently have 3 tables and wondering if having two of tables linking to the same primary key of one table a problem. Then have a form just seperate the two. Here's a quick example Student Info table SSN Name Address Attendance SSN Date...