Create new table query prompts "Enter Parameter Value"

[Jrod2541]

I'm trying to convert a query I made into a table. This query's name is "VendorOrd" and when I run it everything works fine. There are three fields: Vendor, VendorPriority and SKU.

When I run it, the table looks like this:

Vendor | VendorPriority | SKU | Date
ASDF   | 1              | 123 | 140703
ASDF   | 2              | 154 | 140703
ASDF   | 1              | 541 | 140703
FDSA   | 1              | 454 | 140703
FDSA   | 1              | 210 | 140703
ASDF   | 3              | 478 | 140703
FDSA   | 2              | 142 | 140703
 

And here's my SQL code for the output above:

SELECT t1.Vendor, t1.VendorPriority, t1.SKU, t1.Date
 
FROM tblVendorItems AS t1, (SELECT MIN(t.VendorPriority) AS priority, t.SKU FROM tblVendorItems AS t WHERE t.CanShipSameDay=True AND t.VendorPriority>0 GROUP BY t.SKU)  AS t2
 
WHERE (((t1.VendorPriority)=[t2].[priority]) AND ((t1.SKU)=[t2].[SKU]));
 

Then when I try to convert it to a table I made a new query called "CreateTable" which creates a table called "VendorOrder"

The SQL for this query is:

SELECT Vendor, SKU, Date 
INTO VendorOrder
FROM VendorOrd
 

However, when I try to run this, Access prompts me to "Enter the Parameter Values" for SKU and Date. When I just ignore those prompts and click "OK" the query creates the table "VendorOrder".

The Vendor field works fine, but the SKU and Date fields are blank.



Any idea on how to fix this?

[twinnyfo]

Because SKU and Date are numerical values in your query, Access doesn't know how to put them into the table (particularly the date).

I am searching for methods to add parameters to Make Table queries, but am short on time, myself....

[Jrod2541]

It's alright twinnyfo I solved it. Thanks for help anyways. I'll post later explaining what I did, because I don't have a lot of time right now.

Thanks again

[Rabbit]

Just a sidenote, you probably don't want to create a table from that query since the results of that query can change. You would have to constantly recreate that table. It's better to just use it as a query and run the query when needed for the results.