Recent content by kotascye

as soon as i can post pics i will...i dont know anything about functions...my database goes off a query and then a report based off that query....so as soon as i get my post count up ill post pics and then im sure you experts can shoot me in the right direction...

anyone else wish to offer there advice on this??? i cant add isnull or isnotnull to the expression...i keep getting an invalid syntax..then it highlights those words....what do i have to provide in order to get the help i need???

absolutely appreciate everyone's help here...ill try these answers i see tonight...i too am self taught...i can alter vb code all day long, i got a ton of examples from back in my underground forum days... but dont tell me to make up something from scratch...and im learning access and...

idk, it made sense to me...i figured i could add a field in my resident data form for office staff and some how make an expression to group all the guys that are in my office staff on my roll call, but idk how to do this without screwing up the original expr1 in the query, so i give up...perhaps...

I added the staff members field to the resident data form...i was trying to go for a if "yes" like this Expr1: IIf([Office Member]="Yes",[Office Member]) or add it to my existing expression like this Expr1: IIf([Date Graduated]<Date(),Date(),[Date Graduated]),IIf([Staff...

im in need of some serious help....ive provided pics to help with the visualizing and all...EDIT:i tried to provide pics but apparently i need a post count of 10...so no pics ok as u see in my daily roll call report i have 2 groups..."on program" and "graduates" these 2 groups are creating in...

figured i would sign up on this forum as i am looking for advice...i generally can solve my problem with my access database that i use, but ive ran into a toughie and i need helps...anywho, hope someone here can help me solve my issues...thanks!!!