Can I save JUST the Design grid?

[Guest]

Hey everyone,

Is it possible to JUST save the design side of a query (specifically the
formulas I've added to the grid itself?) I'd like to use this query in other
database in the future. I know that it all depends on the table and field
names matching, and I know I can export the query to another database. But
similar to Tables where you can copy just the "structure", I'd like to copy
and save just the design grid and be able to reapply it for future queries.

Is this possible?

 

[fredg]

Hey everyone,

Is it possible to JUST save the design side of a query (specifically the
formulas I've added to the grid itself?) I'd like to use this query in other
database in the future. I know that it all depends on the table and field
names matching, and I know I can export the query to another database. But
similar to Tables where you can copy just the "structure", I'd like to copy
and save just the design grid and be able to reapply it for future queries.

Is this possible?

Just copy the query SQL to a Notepad document.
Any time you wish to re-use the query, copy the SQL from Word and
paste it into the new query's SQL window.
Change the field and table names as needed.
Or...
Import the query from this database into your new database.
From the new database, click on
File + Get External Data + Import
Change the table and field names as needed.