Search results for query: *

When I paste form an access Query into an excel spread sheet it gives me "Error File can not be found" follwed by "Could not paste" however it does paste. This error only occurs when I paste? Any Ideas

In an internet address the # symbol refers to a bookmark or anchor in a page and by clicking the link you will be taken to the page then jump down to where the bookmark is. e.g. www.mydomain.co.uk/index.html#exaple will go to the page index.html then find the bookamrk/anchor example and jump...

You can remove buttons for the user by slecting the startup option unter the tools menu. There are then a list of tick boxes of which buttons to display.

All boxes in row 3 are giving me #NAME? which I understand as an invalid refrence. Now looking at the formula and double clicking it so it highlights the dependant cells it looks fine?

I have generated the following totals from 15 questionnaires where people could choose the options 1 to 5 Option: 1 2 3 4 5 Total: 5 5 1 3 1 *This is example data However I wish to find the median number but if I use the Excel calculation for median it gives me the median for the 5,5,1,3,1...

I am having the same problem but in a WHERE query in access but nothing above works. Like above typing in the value works but not the refreance?

I have as frm_main is the form and test is the textbox on the form which i am tring to read as below: Forms![frm_main].test and Forms![frm_main].test.text which should both work?

I am having problems with a WHERE clause in my cross tab query. If I change it to a standard query or manually type in a value it works fine however the cross tab query will not work by refrancing it to a form. It shows the number of people who answered each level of difficulty for each...

I eventually managed it by creating 3 seperate cross tab queries and then putting them together in another query thanks for the offer of help any how

Is it possible to use multiple fields for the column headers of a cross tab query while only having one row source? and if so how?

Fixed. Opps Just needed to change the link between tables

I am creating a questionnaire database where the user can pick between 5 options in each question. The values in the database are stored as a number in a single field betwen 1 and 5 with the question number in another field. I wish the output to count how many of each result thre has been as...