Search results

  1. Y

    Converting an excel formula into access query formula

    I thank you Sir very much. :D Okay I'll make a new thread and this time directly using the Access. I'm not going to convert the excel formula per se instead I'll do another formula that will output just the same in my excel. Can you help me how to do that? So that they can understand it and...
  2. Y

    Converting an excel formula into access query formula

    This is my excel, it's fully working and I erased some data but the titles and formulas are still the same. This is just an example but same format of what I am doing. :D
  3. Y

    Question Database for a strip club. :)

    It can fit as many as you like in a big table, "Good" Sir. :D :cool:
  4. Y

    Question Database for a strip club. :)

    And even you, "Kind" Sir. :p
  5. Y

    Question Database for a strip club. :)

    I detected a very "naughty" double meaning in this sentence of yours, "Good" Sir. :D
  6. Y

    Converting an excel formula into access query formula

    I don't understand some parts of the formula so pls. bear with me: :) =IF(COUNTA(N1214)=1,-50000,IF(COUNTA(L1214)=1,-50000,IF(I1214-'Date Now'!A1237<-1,(ROUNDDOWN(I1214-'Date Now'!A1237,0)),(IF(I1214-'Date Now'!A1237<0,ROUNDDOWN(I1214-'Date Now'!A1237,0),(ROUNDUP(I1214-'Date...
  7. Y

    Converting an excel formula into access query formula

    This is what I understand based on my learning ability of the excel data and formulas. I have 14 columns which consists of 14 Titles: 1. No. => The corresponding Number of the data. It's in a chronological order but the numbers corresponds to "Date Now" sheet. I mean you can create many...
  8. Y

    Converting an excel formula into access query formula

    Can't I just explain it here? :confused: what do you mean by English? As in I'm going to explain it in a sentence is that what you mean by English? And now that I think about it you will really not going to understand it because I left out some details. :banghead: I'll upload the excel file when...
  9. Y

    Converting an excel formula into access query formula

    Hi Brian, I understand what you mean by checking the same field twice and using the "COUNTA" BUT as far as I knew my questions are correct because I'm already using the excel formulas and are working just fine and actually there's still another formula which is the continuation of this one that...
  10. Y

    Converting an excel formula into access query formula

    I really need some help about this. Can anyone explain to me how this will work? :confused:
  11. Y

    Converting an excel formula into access query formula

    I forgot the output should be in real number .
  12. Y

    Converting an excel formula into access query formula

    Hello! I am having a problem converting an excel formula, I already have converted some of it but an error always shows up. If anyone could help me with this one it is very much appreciated. :D This is the excel formula: (I'm not the one who made this but I can understand the flow of the...
Top Bottom