Code:
Rank: ((Select [B]nz([/B]Count(*)[B],0)[/B] FROM QryDistinctFacturationEquipe Where [SumOffacturation]>AliasSumofFacturationEquipe.[SumOffacturation])+1)
normalice
Last Activity: Jul 12 '11, 01:10 PM
Joined: Dec 3 '10
Location:
-
I think the nz function works for count. Try:
-
so, what would the syntax look like for that sort of operation?Leave a comment:
-
oh
so how do I get the 'client' to tell the 'server' to run the script?Leave a comment:
-
forgive me as I am not familiar with web design.
I assume by "changing the URL... [from] PHP" you're saying it has something to do with the line:
what would i change it to in order to run vb?Code:ajaxRequest.open("GET", "ajax-example.php" + queryString, true);
You then mention writing a VB script - would the underlined in the original post suffice?
in the...Leave a comment:
-
thanks again.
now my question is one of syntax.
i googled "how to make an ajax sql request" and this is what came up:
...Code:<script language="javascript" type="text/javascript"> <!-- //Browser Support Code function ajaxFunction(){ var ajaxRequest; // The variable that makes Ajax possible! try{ // Opera 8.0+, Firefox,Leave a comment:
-
Thank you for the response.
I'll dig around to see if I can get an understanding of exactly what you just said, but in case you (or someone) gets this before I find an explanation, I gotta say: I have no idea what AJAX is...Leave a comment:
-
running SQL from a remote web page
I'm not sure if this better qualifies as an Access question or an XML question - unfortunately, I don't see how to list it as both.
Anyway, I'm sure no one has asked my question because it seems like it is far too simple of a task for anyone to wonder about unless they are completely ignorant - which is my case.
I have two text fields on my web page (feel free skip past this if you want - i promise this is an Access/XML... -
Running SQL from a web page?
I'm not sure if this better qualifies as an Access question or an XML question - unfortunately, I don't see how to list it as both.
Anyway, I'm sure no one has asked my question because it seems like it is far too simple of a task for anyone to wonder about unless they are completely ignorant - which is my case.
I have two text fields on my web page (feel free skip past this if you want - i promise this is an Access/XML... -
determining variable type 'compatibility'
i am importing data from many text files which sometimes contain an error. These text files include dates, strings, and integers, but in order to make this program as hands-free as possible, i need to import all fields as text - in the event of an error in the text field, a field that is usually a date may actually turn out to be something like "12/2/20x[38475934f59dr.g pi9087304d0i". If i try to set the field in the destination table to... -
that's actually what i'm using now, but it's a lot slower than just pushing the "Export to excel" button you see when you have a query, and I can't make the excel display the data as a pivot table, because I'm not all that familiar with excel vb. I would just tell people to use access's own "Export to Excel" button, but I don't want to display the query, and I'd rather have the export button on a form anyway.
is...Leave a comment:
-
How to export an unsaved query to a new excel workbook?
I would like to generate the SQL text for data to export to an excel workbook. Further, I would like the workbook to have no saved location - just a new workbook (the default "book1", "book2"...) . Lastly, the format of the data (pivot table, datasheet..) should also be optional.
I know access must be capable of this, because pushing the "Export to excel" button does exactly what I'm looking for, with any... -
Hmm.
I'm using Access 2003. I wouldn't think the SQL syntax would be so vastly different, but apparantly it is.
it works fine in my recreation, and I can't open yours since I'm using 2003 :-/Leave a comment:
-
what version of access are you using? that's not an error i've ever seen so i might be using an older/newer version than you?
also, your [Weekly Machines Sales data] table, does it have a [Machines Sold] field? I don't see it in the picture, and that would cause an error if it didn't have that field.
If not and each entry counts as one sale, try changing the 'Sum([Machines Sold])' to 'Count([fkVendeurid])'Leave a comment:
-
i'd imagine the sales are stored in a table somewhere?
in that case there are first two questions you need to know in order to solve this: what to do in the case of a tie and what to do in the case that all but 4 or less people sold zero machines.
your question is similar to generating praeto charts, which in general, you will have to set up two queries for those. Because you want to add the extra dimension of points, you...Leave a comment:
-
looking for a basic meta-search function
i'm not trying to compete with google here or anything, so there is no need for anyone to get defensive (i noticed a bit of that with questions related to mine); i simply have three different library catalogs (they are open and public so there are no permission concerns) that i want to search simultaneously - a simple key word search and then display the number of hits for each of the three libraries in a PHP/Python Plone environment. I do not need... -
does the timer event code work while other code is running?
i didn't know that.Leave a comment:
-
a makeshift progress bar
Hello, I wrote some code that loops over several thousands .CSV files, imports them into a remote table, alters the data to be compatible with the database, and stores them in another remote table. After every file it also checks both the import to and export to tables to ensure they are not approaching the size limit. If the export table is approaching the size limit, it simply creates a new table and starts writing to that. If the import table... -
thanks again, NeoPa.
I haven't actually tried this yet, but I was wondering about a specific situation: if the active control is a button. Buttons don't have a value, but since the activecontrolna me doesn't throw an error, it will try to save the activecontrolva lue - but attempting to do so on a button should throw an error, i think? Wouldn't erroring during the attempt to write the activecontrolva lue cause problems in the if statement...Leave a comment:
-
hey, i had a follow-up question, and since I don't really understand some of the code you posted, i figured I should just ask directly.
In addition to the activecontrolna me and and activeformname I would also like to include the activecontrolva lue: if that changes then also reset the counter.
I think it would go something like this, but I don't know what the question marks (????) would be. I've underlined the parts I...Leave a comment:
-
yes, i thought of that but the only problem i had with it is that it would result in double-saving data. If the data is already stored in access i would like it to stay there.
Of course, if I don't get an answer to this, excel is probably what I'll end up doing.Leave a comment:
No activity results to display
Leave a comment: