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?

can you post a link to the sample of a junction table

but the same players can play for more than one team, will this affect anything?

in my database, i will be having player data which includes an ID, their Name, their position, club, value and their points which will be updated weekly. i will also have teams which are selected by choosing eleven players.

Can my project be done though?

i have trtiede reading about it in one of my school books but i cant relate it to my project. Its so frustrating :)

can you explain how to use normalisation in relation to my project?

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

how do i do that i am new to databases

ok but how would i write the query because when i add the players together, it adds all of the teams, not each one on a seperate line and it only adds the player ID, not the player points

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