Query result to a table

#1

I have a table: Table(blah, blah, date1, date2, differenceOfDays,
blah)

I made a query using MS Access, which subtracts the dates to give the
number of days in between. And it shows the correct values on the
query screen (made up of Date1 Date2 differenceOfDays).

My question is, how do I make the result (which is in the query) to go
into the actual table cell?

Sklar

#2

You use an update query.
Look in the help and it will have some explanations.
Here is a step by step example:
http://www.wcape.school.za/subject/C...uer/update.htm

Good Luck
Ira Solomon

On Mon, 10 Nov 2003 16:35:36 GMT, iuy (AT) ih (DOT) com wrote:

Quote:

I have a table: Table(blah, blah, date1, date2, differenceOfDays,
blah)

I made a query using MS Access, which subtracts the dates to give the
number of days in between. And it shows the correct values on the
query screen (made up of Date1 Date2 differenceOfDays).

My question is, how do I make the result (which is in the query) to go
into the actual table cell?

Sklar

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query result to a table

comp.database.ms-access comp.database.ms-access

Query result to a table - 11-10-2003 , 10:35 AM

Re: Query result to a table - 11-10-2003 , 12:22 PM