Search results for query: *

Got it!!! Everything is working beautifully now. Thanks for pointing me in better directions.

I thought I had this worked out... I am attempting to prompt the user to enter the quantity of "labels" when my main report runs. My query on the CountID table and my table of records works great when it stands alone. The subreport with "label" data even works great alone. It prompts me ONCE...

It's taken me a few interrupted days to figure out the details of this approach, but I finally got it. I'm now working out my formatting and needed parameters for it to print like I need. Thank you so much!

Yes, I will have a record source to state how many times I want to show the subreport. I want the subreport to repeat consecutively in one place in the main report.

I have a subreport that results in basically a "form" to be completed after printing. It is not data-dependent. The subreport contains several formatted text boxes--rows where our guests check off age information of family members for us. The subreport is nested among other subreports that...

I figured it out. I used format([RETREAT_DETAILS].[START_DATE],"ddd"). The extra "d" made all the difference! Thanks for the help.

I'm having the same problem with only one subreport. My main report prompts for a beginning date and an ending date, then I get a prompt for the link field that defines my relationship between the report and subreport. I have my the following properties set for my subreport. Link Child...

I did the following: =Format([RETREAT_DETAILS].[START_DATE],"dddd") However, it still came up with "#Name?" when I ran the report... I used the Expression Builder to format my ControlSource.

I currently have the Long Date format for a field in an Access report. I want to use a function or functions that will display the day of the week only. It currently displays "Thursday, October 7, 2004". I want to show only "Thursday". Any help is appreciated.