Search results

Hi All Thanks for all your replies. I have tried all the suggestions you have all advised on. I am using the Data/Subtotals routine and whether I have the subtotals on a seperate worksheet or even another spreadsheet that is linked to the main spreadsheet that I refresh on, when I refresh the...

Hi All I have a spreadsheet which I refresh data on which is stored on our accounts package. I do this using ODBC. I want to insert subtotals into the spreadsheet which I can do, however when I go to refresh the data again the subtotals dissapear and I have to insert them again. Is there any...

Many thanks.

Hi All Is there a quick key to take you automatically to the formula bar to edit what it contains as opposed to clicking in there with your mouse?? I'm sure there must be and I'd appreciate anybody's help on this. :confused:

Hi Yes 12 would be best. Beyond 12 doesn't matter as I will just use the same worksheet for future years. Many Thanks

Hi Many thanks for your help on this. It looks as though it will work great, however, I have added some more rows for months 3 and 4 underneath the others, defined the ranges but when I come to change the if function it doesn't work. I have added just the 3rd index to see if it worked but it...

Sorry Try now.

Hi Shades I have just had a look at the index way and I don't think it is going to work. I have attached an example worksheet of what I am looking for. I hope its pretty straight forward. Cheers.

Hi No I havn't used or heard of that before. Is it quite straight forward and can I find this in help?

Hi I have a worksheet consisting of data in 4 rows and 10 columns In rows 1 and 3 across 10 columns I have dates which are formatted to dd/mm/yy and displayed underneath in rows 2 and 4 accross 10 columns I have number fields. i.e A B C...

Many thanks its worked a treat. Cheers

Hi All I have a spreadsheet where I have hidden a large number of rows which I want to remain hidden. From the information I have left I want to copy this onto another worksheet without it carrying over the hidden cells. I'm sure there must be a way but no matter what I try it copies the...

Hi All I have set a parameter in a query on a number field. When I run the query it lists all entries relating to the number I enter. Once I have ran the query by either opening the query or clicking on the datasheet view when I am in design view, is there a way that I can re-run the query...

Hi Ken I do have a subform called FrmSubformAbsenceDetails which I use to total the holidays/absence shown on another form FrmFullEmployeeDetails. Can I use the total in the form FrmFullEmployeeDetails to sho in my report?

Hi I have a report which runs from a query. It basically is a report I run each week for each employee which they complete as to what their attendance has been for that week. It also lists if they have any holidays booked for that week. The report is run from a query which has a date...

Hi Do you mean revert back to >=30 instead of using <=30? Also I'm not sure how you mean to pull the records through by creating another query from the original as will I not still have this same problem?

My mistake - you will see in my SQL I have >=30 when it should read <=30, but this still doesn't make it work anyway

Get ready its a long one ...... SELECT ACCOUNTING_SYSTEM_STOCK_CONTROL_FILE.THIS_RECORD, ACCOUNTING_SYSTEM_STOCK_HISTORY.THIS_RECORD, ACCOUNTING_SYSTEM_STOCK_HISTORY.ACCOUNT_NUMBER, ACCOUNTING_SYSTEM_SALES_LEDGER.ACCOUNT_NAME, ACCOUNTING_SYSTEM_STOCK_HISTORY.TRANSACTION_DATE...

Dear All I have created a query and within this query I have created a field to calculate a percentage from values in two other numeric fields. This shows the correct information however, I want to add a criteria to this field so that it only shows records <=30 (less than 30%). No matter how...

Dear All I have created a form which I call "Switch" to automatically open when myself or a colleague opens this specific database. This has been set through the tools and then start up option on the menu bar. On this form I have created numerous command buttons to open various forms. Reason...