Search results

  1. C

    Designing your own report

    Hi, I have just finished a script that prints out a report for my company. However, my boss wants me to design the report in the "standard" reporting format for my company. I have never designed my own report, and I am using Access 2002, can't seem to find any good tutorial/guide to design it...
  2. C

    iif statement

    Thank you sir! :)
  3. C

    iif statement

    Hi, I am having some trouble with an iif statement as selecting the field.. I have two columns, one called [sdCounterpartyprice] and one called [bid] I want to select the [bid] if it's not equal to Null or 0, if it is equal to that then pick [sdCounterpartyprice] this doesn't work CptyPrice...
  4. C

    Union query

    Thank you!! :)
  5. C

    Union query

    Ahh of course!! Thank you :)
  6. C

    Union query

    Hi there! I am working with some unions that I have a question. I have 5 queries that I would like to union, 2 of these are missing one column. That way they can not be unioned, my question is if there is a way to "cheat" through this? Making a short example here.. 3 queries have...
  7. C

    Sum of column

    Smoooth! :D thank you!
  8. C

    Sum of column

    Hi! I am having some trouble with a program that contains a query that is suppose to sum a bunch of market values that have the same ID and is from the same portfolio. The problem I had at first was that some of these IDs and portfolios that should have been summed together had one called...
  9. C

    Make table weekday function

    Thanks for helping! :)
  10. C

    Make table weekday function

    Ofcourse, this works for me now. Think I over-thinked the situation and created a problem on my own.. SELECT dbo_pf_tree_mb.child_name, dbo_pf_tree_mb.upload_date, Left([child_name],20) AS child_nameT INTO getSDportfolios FROM dbo_pf_tree_mb WHERE...
  11. C

    Make table weekday function

    SOLVED: I nested myself in this problem, heres the very simple and handy answer... where IIf(Weekday(Date())=2;Date()-3;Date()-1)
  12. C

    Make table weekday function

    Yup still won't get it to work.. But thanks for the help so far :)
  13. C

    Make table weekday function

    No worries! I am creating sort of a new table, I am making a copy of a linked table, and fetching only from a certain date! However I just put your #6 as a new field, and tried it as a criteria.. didnt work :(
  14. C

    Make table weekday function

    It definetly wasn't sarcasm, I just thought that since it worried you, you might had an other solution for it then me.. Since I am quite a rookie at access! So I was merely trying to seek your guidance! For 1. The field is retrieved through a linked database so can't change it... 2. The field...
  15. C

    Make table weekday function

    Tried putting this as a parameter but it didnt work.. Any suggestion how you would solve it? Column name is upload_date and just need something that says if monday do date()-3 else date()-1.. Thanks for trying before tho! :)
  16. C

    Make table weekday function

    Hmm okay, how do you suggest id do it then? :D
  17. C

    Make table weekday function

    Hi there! I am currently working on my iif weekday function in a make table query. What I want it do is that if its monday take date()-3, else date()-1. I cant get it to work.. DateAdd("d", IIf(Weekday([upload_date]) = 2, -3, -1) I tried this, wont work..
  18. C

    Hide duplicates from query

    I would but there are some rows that arent duplicates that still have null values..
  19. C

    Hide duplicates from query

    Hi there! I have a query showing duplicates, I want to hide the duplicates that have a null value in one of the rows.. Trunc_Name M_UNDERLYIN MaturityDate Duration SumOfSumOfM_VEGA Volatility SPX P1400 DEC13 INX 21-dec-13 4,766666667 -108 812,00...
  20. C

    date parameter

    Will try that, think it might work! Haven't got access to db atm so will try later on :) I am not the one that created the db and named field date, some genius at my office did that :banghead: we'll see how it works out! Thank you for your help, and how fast it was given! :)
Back
Top Bottom