Whasis
  Home FAQ Contact Sign in
 
Advanced search
MATCHING GROUPS



more...
POPULAR GROUPS

more...

found 4 articles for 0.302 sec
Hello John, I have three tables, one for invoices, one for customers and one for expense accounts. There are no autonumbers in any of these tables but i have to ask you have described an append query to one table though my spreadsheet will have data three tables. I do not undertand the concept of creating one table to do an append query.Can you assist a little more? "John Nurick" wrote     

Group: microsoft.public.access.externaldata · Group Profile · Search for Whasis in microsoft.public.access.externaldata
Author: jk
Date: May 20, 2007 12:48

On May 10, 11:12 pm, PB <pb4use...@yahoo.com> wrote: Colorado 1, Real Salt Lake 1 COL -- Own Goal (Jack Stewart) 4 RSL -- Own Goal (Pablo Mastroeni) 15 Prior to this game, there hadn't been an own goal all season. P The TV crew was a bit heavy with the Freddy. My take is he could afford to give up size or speed but not both. He'll never be THAT player but can be a solid
Show full article (3.38Kb)
Import the data from Excel as is. Let's call this table AsImported. Create a query based on this table that returns one record per customer. On the basis of your sample data it will look like this in SQL view (the DISTINCT keyboard corresponds to the "unique values" property in query design view). Let's call it tempImportedCustomers: SELECT DISTINCT [CUS ID], [CUS NAME], [CUS ACCT]     

Group: rec.sport.soccer · Group Profile · Search for Whasis in rec.sport.soccer
Author: Cosmos Factory
Date: May 11, 2007 09:25

CUS ID CUS NAME CUS ACCT INV NUM INV AMT INV DETAILS EXP aCCT 10030 MONI 20023 M2503 $100.00 TRVEL 30025 20011 YESI 12500 M2600 $250.00 ENTER 10025 12530 WHASI 30025 M2606 $375.00 RENTAL 20025 10030 MONI 20023 M3000 $1,500.00 RENTAL 16402 I have inserted a sample in that the rows in excell are repeated many times like CUSID 10030. In access, i beleive it to be three tables, one for
Show full article (1.08Kb)
    

Group: microsoft.public.access.externaldata · Group Profile · Search for Whasis in microsoft.public.access.externaldata
Author: John Nurick
Date: Feb 23, 2007 06:41

Show full article (2.83Kb)
    

Group: microsoft.public.access.externaldata · Group Profile · Search for Whasis in microsoft.public.access.externaldata
Author: jk
Date: Feb 23, 2007 05:45

Show full article (1.93Kb)