Search results

HI there, the name of the Database is the file name ( Name:database3 File Type: Microsoft Access 2007 database ) and also shows in the application title-bar. ( database3: database ( Access 2007 ) - Microsoft Access. Funny enough the course I'm doing is asking to write and execute a SQL command...

Hi; My problem is I need to use a query to change the name of my MS ACCESS database from "database3" to "testing". I'm guessing there are other ways such as in the tools but I need a query to change it. Is this possible. Thanks

Thanks for that, This query works well in isolation. My problem is I have to list all the [admission_id] entry's, not just the ones that match the 'Yes' value in the [answer] column. So this query returns only a partial list of the [admission_id] entrys, not all of them.

This is a continuation of a nasty problem I have to write a query for. The count was worked out but now need the average. In a one table I have various attributes. The 3 in question are [admission_id] , [answer], and [mark]. The [admission_id] can have the same value in different rows. (e.g...

It works, fantastic, thanks Bob your a life saver

Thanks for that Bob, I can see where that command line can come into it. Doesn't seem to give me an answer though as keeps asking me to enter a parameter value for admission_idCNT but I think my original post was a little vague. I'll try to explain a little better I have 5 attributes in one...

Have a problem which can't seem to get my head around. I have to write a access query which will count how many times each different attribute has one particular value in one table. So attribute [admission_id] which can be duplicated in this table will have a particular value [yes] or [no] in...