Search results

Hi, i have a table of data, with a user name, and a task. Each user is assigned many tasks, i and i would like to create a query that replaces all instances of a certain name with another name. How would i do that? Thanks Sean

I have two tables: one with all the policy numbers, and another with a few of the policy numbers. How would i make a query, that each policy number is in the other table, then it returns "Yes", otherwise it returns "no"?

Hi, i currently have three tables. Policy table: Policy number(key),date and fund(4 possible strings of four letters) Last Price: date, fund, last price Next price: date, fund, next price What would i have to do to make a table that has a policy number, date, fund, last price and next price...

hi i have a make table query which stores the data i require, but what i want is it to store the data that is usually overwritten every time the make table query is ran. It always gets deleted when i need to keep that data as well as the new data. Any ideas?

Hi, can anyone explain to me in simple terms how junction tables work and how i would go about creating one?

hi I am trying to copy the data from one table into another table. I then wanted to update the table where it is copied from. This data i then wanted copied into that table in another row. Any ideas?

Hi i have a table with 3 columns for different values is their any way of adding together the data from 3 to create an extra column which shows the total of all three added together without using a query?

I am creating a football dream team database with two tables: Team table - Team ID, Team Name, Player 1, Player 2, Player 3, Player 4, Player 5, Player 6, Player 7, Player 8, Player 9, Player 10 and Player 11. All the player columns are lookup functions which are linked to player table...

hi i have two tables. One with Item Data - ITem ID, Item Name and Item Value On another table, i have transaction data - Transaction ID, Item 1, Item 1 Value, Item 2, Item 2 Value etc. What i am looking for is a way of when i lookup item 1 and enter it, item 1 value will appear automatically...

Hi i have two problems. I am creating a football dream team database with two tables: Team table - Team ID, Team Name, Player 1, Player 2, Player 3, Player 4, Player 5, Player 6, Player 7, Player 8, Player 9, Player 10, Player 11 and Points Total, All the player columns are lookup functions...