A Momentary Lapse of Reason

I’ve been working on code to cross-reference data sources, tables or queries, against queries, tables, and forms.  And I finally have a workable solution.  I will publish it here, but it needs a little cleanup first.

I recently generated such a report and found a surprising number of reports that weren’t using a query for their recordsource, they had SQL statements instead.  There’s nothing wrong with that, but all of a sudden I had to use a memo field for the cross-reference, which you can’t sort on.

The biggest offender?  A select statement that named 22 fields, complete with the full name of the query, which was upwards of 40 characters long.  And after all of those field names?  A *.  And there’s only the one table for the report.

I don’t know what I was thinking.  Shouldn’t be too difficult to clean up.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s