Search results for query: *

An update to my post: The text should not be carried over. Sorry for the typo. The goal is to create a blank calendar for the upcoming month. Thanks.

I am using the "Understated" template in Publisher 2010 (Windows 7) and wish to add a new month and carry over the existing month's text. I go to Page Design, click Change Template, click Set Calendar Dates..., and select the new month as the start and end dates. Selecting "Apply template to the...

Yes! This is perfect. Interesting how you use two instances of the same table, one to group and the other to count. My SQL/query skills are moderate at best, so this was an eye opener. Terrific query lesson. Thank you so very much.

Unfortunately not as all IDs are autonumbers. The Child1, Child2, etc. represents the number of child records linked to each parent record. The real child table data might look like this: ChildID lngParentID datEvent 1379 915 08/01/11 2426 915 08/02/11...

The resulting query does not need to be editable. The unique field to order by is the child date field (ASC) to determine child record order. A query would pull the first four columns to which I would need the ChildRecOrder (5th column, either an update to a temp table or as a calculated...

I have a parent table named tblParent with one child table named tblChild. The structure is: tblParent ParentID [other fields] tblChild ChildID lngParentID [other fields] Background: A form (frmParent) with a record source of tblParent has a subform of tblChild. Two unbound textboxes are...

Couldn't figure out how to make this work. A workaround is to put Me.Filter = "" and Me.FilterOn = False in the Report_Open event. Thanks.

I have an access 2007 report where the Default View property is set to Report View. I have an unbound textbox on the same report where the Control Source is "=[Report].[Filter]". When the report is run, any field can be filtered by right-clicking the field and selecting appropriate criteria...