Append Query

[sha123]

I have a table called Orders with 3 Day fields called:

1)Day1 2)Day2 3)Day3.

I now need to create a append query to copy these days into one field in a new table, but I now need it to ask which days need to be copied into the new combined field called combined.

How will I do this?

 

[scriverb]

This requires two queries:

Save this SQL as qryDayValueSelect:

SELECT Switch([Which Day?: "]=1,[tblDays]![Day1],[Which Day?: "]=2,[tblDays]![Day2],[Which Day?: "]=3,[tblDays]![Day3]) AS SelectDay
FROM tblDays;

Save this SQL as qryAppDayValues:

INSERT INTO tblNewDays ( DayValue )
SELECT qryDayValueSelect.[SelectDay]
FROM qryDayValueSelect;

Now just run the query qryAppDayValues to append the values from the selected field from tblDays to the new table tblNewDays. You will have to create the new table first with a field named DayValue(numeric-Long). This second second query could be a make-table query where a new table would be created each time your run it. It would delete the old query and create a new one based upon the day value selected.

Post back and let me know if this is what you need.

Bob Scriver
[blue]Want the best answers? See FAQ181-2886[/blue]