Search results

  1. M

    replace all query

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

    Check if in a table

    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"?
  3. M

    Create a table from 3 other tables

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

    make table query

    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?
  5. M

    Junction Tables

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

    Copying data to a new table

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

    Calculatinng Totals

    can you post a link to the sample of a junction table
  8. M

    Calculatinng Totals

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

    calculation query

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

    calculation query

    Can my project be done though?
  11. M

    calculation query

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

    calculation query

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

    calculations in tables

    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?
  14. M

    calculation 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...
  15. M

    automatic lookup

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

    Calculatinng Totals

    how do i do that i am new to databases
  17. M

    Calculatinng Totals

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

    Calculatinng Totals

    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...
Back
Top Bottom