Search results

I recently came across the GRANT statement in Access which can be used to give certain users assigned privilages, so my question is; is there an equivalent method which can be used in excel. This isn't a vital request, just curious. Thank you in advance.

Is there a way while using the count query to make it return zero when using the criteria (not like "N") instead of a blank datasheet.

tried Thanks for that, had already tried that. what is happening is one of two things, a) a return of the count of all values in the field (thats what it should do) or b) if i change the criteria to count items not in the field returns nothing (once again doing what it should be) The result...

This is a frustrating problem, I want to count all entries in a field that are "N" but instead of displaying the total count ie 120 i want it to show 0 until "N" is replaced by "Y". what I have got so far is SELECT [CABLE DATA QUERY].TOP, Count([CABLE DATA QUERY].[Cable Test]) AS [CountOfCable...

cheers That little prototype worked so I just have to expand on it. Thanks for the help :D

will try Appriciate that james, I knew this was going to be a stinger :eek: but didn't realise how much plus kinda teaching myself vba as I go along. :o

Thanks mark I knew of this and it will generate a new excel sheet for me, however this wouldn be sufficient as I need to update an existing excel worksheet and only specific cols and cells. But thanks anyway

What I would like to do is export certain data from a report made in access to specific cols in an excel sheet (Within a certain range, eg A3:A78, A86:A119). Firstly is there a simple way to do this or will it require a certain amount of code.