Recent content by Kiz

  1. K

    How do I group rankings??

    Oh my god! THANK YOU THANK YOU! It worked perfectly! You, my friend, are awesome! :D
  2. K

    How do I group rankings??

    I have tried dropping it in through design view.. but it comes up with an error. I know I am being a pain, but I really suck at SQL! Can someone please drop it into my above SQL query so I can see where it goes? Thank you!!!!
  3. K

    How do I group rankings??

    Hi all, I have used Allen Browne's suggested method of ranking to rank by the date each client settled... Now I need to group the rankings by the referring company as below... so it ranks each client referred by referral company from earliest to latest - like so...
  4. K

    Need to build a query to show ranking/order of sales

    Hi all, I am creating a db for our sales team, we have commission incentive kickers (e.g. after the 3rd deal, commission goes from 10% to 20%). I need to build a query to show the 1st, 2nd, 3rd etc deal for each sales person. I have the 'Sold Date' and 'Sales Person' in a query, but not...
  5. K

    Need help with filtering report to only show current month's report

    OK so i have tidied up my database somewhat. If you have a look at the report called "rptTrailKF" you can see that this creates the reports i am after (sort of)... but what i need to know is how to only generate these reports for the current month. I havent created a form before, but i am...
  6. K

    Why does access keep asking me to enter parameters?

    Thanks for your suggestions, so I guess it is very obvious I am new at this! ;) I will definitely work on the other suggestions re: naming and normalization... however, in regards to my original query, I can't see any aliased field name. What I have done is 3 calculated query fields (Payable...
  7. K

    Why does access keep asking me to enter parameters?

    Thank you for that, has this attachment worked? I had a look at the names, they seem right to me... So confused! :confused:
  8. K

    Why does access keep asking me to enter parameters?

    Hi all, I am very very new to access, i have built a database with a query that has a couple of calculations, they seem fine in the datasheet view, but i keep getting asked to enter a parameter value. I have attached my access file to have a look at. Thank you in advance!
  9. K

    Need help with filtering report to only show current month's report

    Hi jdraw, Are you able to just click through them by clicking OK? I need to do some tidy up but those fields are not relevant to the report.
  10. K

    Need help with filtering report to only show current month's report

    Hi all, Let me start off by saying that I am VERY new to MS Access! The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I...
  11. K

    Accessing Crystal Reports through MS Access

    Hi all, I am using MS Access 2010, building my first ever access database. I have worked out how to pull data from excel however, I am now trying to pull data from Crystal Reports 10. I am using the ODBC button, however I keep getting an error, along the lines of "need to install driver"...
Top Bottom