Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. lancemakali

    BO SUM not giving expected result

    maybe i'm complicating things when showing you this example. I'll try to explain in even simpler way without refering to what I've tried so far. so, I have 3 objects in my report: - Outlets - Sales - Brands And I need to find out something like this: BRAND A is sold in 400 outlets, I want to...
  2. lancemakali

    BO SUM not giving expected result

    Hello everyone, I've been struggling for weeks to solve a problem and honestly I don't get it although at first it looks quite simple. In short, I have this: - brands - outlets - sales For each BRAND, I would like to have the TOTAL SALES OF THAT BRAND against TOTAL SALES (all brands...
  3. lancemakali

    Copy a query result from access in the clipboard, without the headers

    Thanks, guys, I'll give this a go later on today or tomorrow :)
  4. lancemakali

    Copy a query result from access in the clipboard, without the headers

    Hi, Thanks for that. But this looks quite a complex thing to me.... and I'm not using HTML nor ASP. I said SAP, it's not a typo ^^ But basically, forget the SAP part, if you copy/paste the quer result in notepad, same happens, columns headers are there, and I just don't want that. Hope this...
  5. lancemakali

    Copy a query result from access in the clipboard, without the headers

    Hi everyone, I believe this has been posted before, but not exactly in the same way I want it, and even then, the solution I've seen so far haven't been helpful in any ways yet. I honestly searched a lot for the answer today, everywhere I could think of, but since I'm no VB specialist I thought...
  6. lancemakali

    weeknumber

    I already tried that, but that is not giving me the result I want. Looks at below screenshot: - 1st column is obviously the day I would like to know the week off - 2nd&3rd columns are actually the same things, but different formatting. These objects calculate the week but the result is not...
  7. lancemakali

    weeknumber

    Thanks for your reply; It's an Oracle database, if that can help. Well, basically, if at least I'd know what's hiden behind that "week()" function BO has, I could potentially translate that into an object... but honesly, no clue.
  8. lancemakali

    weeknumber

    Hi Guys, I'm probably asking something very stupid here, but anyway. I would like to have an object that gives me the weeknumber of a certain date. I managed to do that by creating a variable like this: =Week(<Day>) Nothing too chinese so far. But to make it even easier for the mere mortals...

Part and Inventory Search

Back
Top