Recent content by Emmy

Thanks so much Pat; it works! Thank-you so much for your help, I really appreciate it! Thanks again, Emmy

Thanks very much for your help, I really appreciate it!! I followed your example, but depending on how I join the tables, it either appends the same record dozens of times, or I receive the error message: "The SQL statement could not be executed because of ambigious outer joins. To force one...

Thanks for your reply. Sorry, I am still very confused. The two tables I have are: Table 1: contains the imported data from my spreadsheet Table 2: The table I want to append to, which contains the lookup field By appending the numeric field (the lookup field) to itself, how does the table...

I followed Pat's example, and I get the error message "Type Mismatch" - from design view, the text field is joined to the lookup field, but since one is text, and the other is a number, there doesn't seem to be a way around this......? Any suggestions would be much appreciated, thanks so much.

Thanks for your reply. Sorry, I am still lost and am not sure what I need to do. From Pat's example, which table is the lookup table, S or L? How does Access know that when it sees "apple" from the imported table to append "69" to the existing table? Is this through a join? Thanks very much...

Could someone please give an example of how to create a separate query that performs a first join, and then include that query in a SQL statement? I followed the example in the help menu, but it doesn't seem to work? I don't really know how to use SQL...is there a way to modify this using...

Thanks very much for your reply. Sorry, I don't know how to use SQL...currently I am just using "Design View" to create my queries in Access so I am a bit lost. >In your append query, add the lookup table >and join to it on the text field. Then >rather than referencing the text field in >the...

I need to append data from a sheet to an existing table. One of the fields in the existing table is a lookup field (its data type is a number.) How can I write a query to append a string of text to this field? If I append the primary key which corresponds to the text, it works, but the...

I am writing a query. One table has unique records with people's names and a unique number for each record, (i.e. Jane is 83, Mary is 72, John is 100) One table has telephone numbers with a unique number for each record. (i.e. 1234567, 2223456) But when I write an append query and refer to...

I have a question about an append query: I have exported a spreadsheet from Excel to a table in access: Column 1: Female Telephone Number Age Column 2: Jane 1234567 25 An explanation of how the database is set up: * I have one table called "Gender", this table contains only 2 records...

Thanks very much for your help. I have a table called People. When I click on the "+" in far left hand column in "People", it expands to another mini table "Information" that contains data about each record in People (i.e. age, telephone number, etc). Please note that there are only two...

Hi, How can I write query that displays not only the record, but specific records that are linked to it? * I have a table named "Person" with two fields, "Name" and "Occupation". * On the left hand side of the table "Person" I have a little "+" that expands and links to another table...

Hi, How could I write a query that randomly selects 100 records from a table? Each record has a unique record ID. Thanks very much for taking the time to read this.

The following is a table: row 1: 6/15/2001 row 2: row 3: row 4: row 5: row 6: 6/16/2001 row 7: row 8: row 9: row 10: (rows 2 to 5 and 7 to 10 are blank) Is it possible to write a query such that it fills rows 2 to 5 with "6/15/2001" and rows 7 to 10 with "6/16/2001"? Thanks so much!