How to create a teble from a query (1 Viewer)

icedearth

Registered User.
Local time
Yesterday, 21:18
Joined
Oct 10, 2008
Messages
24
Hi!

I have a result of a query and i want to make a table from that result.
 

KenHigg

Registered User
Local time
Yesterday, 20:18
Joined
Jun 9, 2004
Messages
13,327
Change the query type to a 'Make table' query and run it.
 

KenHigg

Registered User
Local time
Yesterday, 20:18
Joined
Jun 9, 2004
Messages
13,327
You're pretty fast for a Monday Brian - :p
 

Rabbie

Super Moderator
Local time
Today, 00:18
Joined
Jul 10, 2007
Messages
5,906
In Query Design view press the Query Type button. Then select Make Table query from the drop down list. You will be prompted for the table name you wish to create.
 

Rabbie

Super Moderator
Local time
Today, 00:18
Joined
Jul 10, 2007
Messages
5,906
3 of us agreeing on the solution.:eek: Better double check we have got it right:D
 

Brianwarnock

Retired
Local time
Today, 00:18
Joined
Jun 2, 2003
Messages
12,701
Sorry for the delay Ken, I'm just popping on when having coffee, her-in-doors has got her list out so have been doing a few jobs. When you posted at 9 00 am your time it was 2:00 pm here.

Brian
 

KenHigg

Registered User
Local time
Yesterday, 20:18
Joined
Jun 9, 2004
Messages
13,327
Oh... So where talking 5hrs ahead of us. Mybe later this week you can tell us who won the election before we vote - :p
 

Brianwarnock

Retired
Local time
Today, 00:18
Joined
Jun 2, 2003
Messages
12,701
Oh... So where talking 5hrs ahead of us. Mybe later this week you can tell us who won the election before we vote - :p

The UK has always been ahead of the U.S. Ken ;)

Its Obama.


Brian


better quit before we hijack this thread :eek:
 

Rabbie

Super Moderator
Local time
Today, 00:18
Joined
Jul 10, 2007
Messages
5,906
Oh... So where talking 5hrs ahead of us. Mybe later this week you can tell us who won the election before we vote - :p
I would say Obama barring a miracle. rtemember tho that although we are five hours ahead timewise in somethings we are twenty years behind.:D
 

Users who are viewing this thread

Top Bottom