Search results

Thanks Ginny, I have the blank cells selected but whilst they are empty line graph drops to zero until data inputted into cell; I just want the line to stop at end. Hope that makes more sense.

I want my chart to display a line graph without dropping at the end of the line where data is still to be inputted. I need the chart to have the blank cells included so that it updates automatically. The cell references used in chart refer back to other worksheet. Using IF statement...

My pc is set to 24hrs but my macro will not recognise it. I have 2 columns, one with date and time (time in 24hr) and the next column calculates the hour only from the 1st column. When I record the macro it works fine and the hours returned from the calculation are in 24hr as they should be...

Thanks for your help, will give this a try.

Can someone help; I have attached spreadsheet with 3 columns. I want a macro to delete rows which have 'Site' in the 1st column and/or 'Refund [Debit]' in the 2nd column. I have no knowledge of VB code but am still hopeful this can be simple! :eek:

I don't know visual basic but the idea about making a table for the months etc makes sense. I have a field for the LeaveDate which is a date. I will try and put some of this into action and see how I get on. Thanks.

I want to show how many staff worked for us throughout each month of the year. I think I can only use their start dates to work this out but I don't see how I can calculate to say there were 100 staff in April and 120 in May etc. when it will be the same people month on month give or take new...

Many thanks, I will give this a shot.:)

I have a form based on a query which calculates employees ages from the date of birth which in turns derives from a table. I want to be able to analise staff based on their age group, e.g number staff 16-20yrs, number staff 21-25yrs. I know how to group and count but can I create a calculation...

This is hopefully straight forward to resolve: I have a report which contains a name including title at start. The title comes from a table called Title where the primary key is an autonumber in order to put the various titles in a sensible order rather than alphabetical when selecting from...

I have tried it but it comes back with errors like most things I do with Access! For example, I have created 5 search combo boxes with the wizard and only 3 work, but they were all created exactly the same way.

Isn't there a way to do it without knowing visual basic?

Can anyone tell me how to do the following: :confused: I have a drop down list on a field on a form. Depending on what is selected on this list will determine the option on the next drop down field. E.G List 1 Dog Cat Fish Following lists appear depending on which in List 1 is selected...

Can anyone tell me how to do the following: :confused: I have a drop down list on a field on a form. Depending on what is selected on this list will determine the option on the next drop down field. E.G List 1 Dog Cat Fish Following lists appear depending on which in List 1 is selected...