Search results for query: *

Is ACCOUNT.LETTER a date field? Looks like text. Try: WHERE ((([ACCOUNT Query].MAJCOM)=&quot;PRIMARY&quot;) AND (CDate(ACCOUNT.LETTER)<DateAdd(&quot;yyyy&quot;,-1,Date())));

Need each department's data to start on new page. Setting Department Header Force New Page to Before Section leaves first page without data. Setting Department Footer Force New Page to After Section forces Report Footer to new page (undesirable, especially when the report is limited to one...

Have you double-checked your tab order? Can you get to a new record via navigation buttons? I've added a &quot;next&quot; button at the end of a form before, but there was some other specific reason for that.

Nothing equals Null. Try IsNull([IncidentDescription]).

Look at the InStr function. You probably want something like: Right([fieldname], Len([fieldname])-InStr(&quot;>&quot;,[fieldname])) (check all syntax - I'm a little out of practice)

Are the Section's CanShrink and CanGrow properties also set to yes? Try decreasing the spacing between subreport controls until they all touch, no white space between and no overlap.

Don't know about tab controls, but your form has a Cycle property you can set to Current Record.

You can link to all your tables, and use a union query if you want to use them all together again. Why do you need to keep each year separate, and how else were you thinking of accessing them again?

Good point, Michael. I took the question literally and figured it wasn't going to be used on Monday.

Why in the world would you want to do that?

Between Date()-weekday(Date(),vbMonday) And Date()-1 should do it; got help from the immediate window.

How about Between Date()+1-weekday(Date()) And Date()-1? Or tell the weekday function that Monday is the first day of the week (don't use the function, but have heard it can be done) and skip the &quot;+1&quot;.

Have you tried something like CDate([month field]&&quot;/&quot;&[day field]&&quot;/&quot;&[year field])?

...not a dup and not after a gap, previous was one less CodeStatus.CodeRt = CodeStatus.CodeRt - 1 End If If StatusFlag = &quot;*&quot; Then 'If it's after a gap, previous was at least two less CodeStatus.CodeRt = CodeStatus.CodeRt - 2 End If...

...not a dup and not after a gap, previous was one less CodeStatus.CodeRt = CodeStatus.CodeRt - 1 End If If StatusFlag = &quot;*&quot; Then 'If it's after a gap, previous was at least two less CodeStatus.CodeRt = CodeStatus.CodeRt - 2 End If End...

Um, yeah. Concatenating would be simpler than nesting.

You would need to nest your IIfs, more like: IIf([Local School Districts]=-1,&quot;Local School Districts&quot; & IIf([Academic Educators]=-1,&quot;Academic Educators&quot;,&quot;&quot;),&quot;&quot;) IIf(condition1, truepart & IIf(condition2, truepart & IIf(condition3...

...End If End If If (Not blnNoCalc) Then If (CLng(CodeStatus.CodeRt) + 1 <> [CodeRt]) Then StatusFlag = &quot;*&quot; End If End If Me.txtStatus = StatusFlag With CodeStatus .Branch = [Branch] .CodeRt = [CodeRt] End With End Sub...

If your LoadingCity is Not In List of a combo box, try Forms![PreviousForm]![LoadingCity].text

What in your macro is calling for the dates? Your query doesn't need to be open before the report, but the form does, otherwise Access has nowhere to look for the dates and will ask you for them.