In SQL Server I would just add a blah=' ' in the select statement, but I can't seem to get that to work under Access.

If you've been searching for a way to use the table structure in an existing Microsoft Access database in another table, then check out this quick tip. It shows how to copy and customize the table ...