General information
Category:
Forms & Form designer
Hi Steven.
>> I then run the select statement to create a cross tab query that tabulates the days of the week as column headings and groups the job no.'s into rows. Usually we only work 5 days a week. However there has to be provisions for Saturday and Sunday work. In my grid I have columns that list Sat/Sun. with their control source set to respective columns generated by the crosstab. But if no time is entered for Sat or Sun the crosstab won't generate these columns. Therfore leaving to grid no control source for these columns. <<
What I would do in this case is create an updateable cursor in the Form's load to use as the RecordSource for the grid. Then, you can run you crosstab query into a temporary cursor to get the data you need. Next step is to ZAP the grid's RecordSource and APPEND FROM DBF( 'TemporaryCursor' ) and refresh the grid.
Marcia
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only