Search results

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...

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!