Search results

Hi Gemma, Thanks for pushing me to do this Formula1db for 2008. I'm not entirely happy with it (see db attached), but it's a start. 1. Can you see any reduntant information or an unnormalised structure and does it conform to 1-3NF? General feedback also welcome... 2. Do I need to turn the...

delete or unmatched? OK. Many Thanks. This has done the trick. It's just that I thought there was an easier way of doing this by dragging and dropping the ID of the second table in the query viewer.

Thanks Khawar, Do you know how I would do this using the query interface? I tried dragging and dropping yesterday, but with no success.

In this example I have two tables: Table A has numbers 1-10. Table B has numbers 1-4. What I would like to to is to remove all records in Table B from Table A, so I am left with records 5-10. I have already done this using an unmatched query, but would it be possible to do this using a...

telephone numbers to clear How would I do that? All the 1,000 numbers are different so the 300 would all be individual ones that need to be selected manually, initially finding out who the named person is and then relating that to the telephone numbers. I could of course do this manually in...

Top 300 How do you do TOP 300? And what if all the telephone numbers are not in order? ie. not the TOP 300? Would I have to repeat this code for each one and how? UPDATE Sheet4 SET ISBN = ' ' WHERE ISBN='02 678 3457'; Can the telephone number data for deletion be modified more easily?

If I have 1000 records, of which I would like to replace 300 of a field with a null value to replace selected telephone numbers, how is this done (for all 300) using either (a) SQL viewer (or/and) (b) the query builder? I would like to do all 300 in one go and only replacing the appropriate...

Thanks: 1NF-3NF Many Thanks George and to redneckgeek. I'll try to find some time to set up this db. over the weekend, so I get an idea of what it's like with data added. It's quite important that I understand these concepts as I'll want to set up a Formula 1 motor racing db. at a later date...

Could someone please explain this to me. I have extracted the data from an internet site but can't quite understand a few things relating to table relationships, design and content: Students Table has following structure (1NF): studentID name dateofbirth advisor advisor'stelephone student...

OK- thanks. This worked: Replace([Teams.Team],"Inc."," ") This worked, but not in the 'update to' area of the query: Trim( Left( "American Express Inc.", Len( "American Express Inc." ) - Len( "Inc." ) ) )- it says 'The expression you entered has an invalid. dot or ! or operator or invalid...

Hi, I am trying to delete a part of a string but not all of it. For example; American Express Inc. I would like to delete only the "Inc.", but leave "American Express". How is this done? Many Thanks, Tim

Hi- I have used Access before but am setting up my first 'proper' db in it. This is for a Formula 1 2008 motorsport db. I have set up a Drivers and Teams table, including a driver points table for each race. I will try to expand this db later, but just have a query on a couple of things for...