Search results

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

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

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

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