Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: kstearns04
- Order by date
-
I NEED HELP PRINTING A REPORT WITH CHECKBOXES
Do you actually need the y's if the text information is being displayed? Are they in specific columns? You can create the string with INFO: IIf([Married]=True,"Married") & IIf([Kids]=True," Kids")...) in your recordsource. Then display the y's within the proper columns...- kstearns04
- Post #3
- Forum: Microsoft: Access Reports
-
After DateAdd function values do not sort as dates
Thanks for the info! I ended up using a format command on the field WEEKENDINGDT: IIf(([WEEKENDING]=0),"",Format(DateAdd("ww",[WEEKENDING],"12/31/89"),"yyyy/mm/dd") and the Between...And statement Between...- kstearns04
- Post #3
- Forum: Microsoft: Access Reports
-
After DateAdd function values do not sort as dates
I have an Access DB which stores a Week Ending value as a number. I have created a report which needs the actual Week Ending Date which calculates fine (WeekEndingDt: IIf(([WEEKENDING]=0),"",DateAdd("ww",[WEEKENDING],"12/31/89")), however when I sort, I get...- kstearns04
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
-
Datasheet View to Form view
On your subform properties choose Datasheet as the Default View and be sure that you have 'Yes' on Record Selectors. Use the following code on the Double Click event of the subform: DoCmd.OpenForm "formname", acNormal, , filterfield = Me!filterfield When you double click on the...- kstearns04
- Post #4
- Forum: Microsoft: Access Forms
