Search results

  1. C

    Creating Calculations in Reports

    plog, Apologies, pardon my stupidity, I'm really struggerling with this one. So I'll list everything I have data wise and try and explain it better, I admit I have been a little vague. In the query I have 4 tables: Quotes, Projects, Tenders, CustomersMain - I want to build a query that will...
  2. C

    Creating Calculations in Reports

    Hi, I've managed to get it to run the query, I realised I have closed off the expression after the [Project!WonLost] This is what I have now, however each record shows £0.00. TotalOutstanding: Sum(IIf([Project!WonLost]=Not 'Won' And Not 'Lost',[ContributionValue],0))
  3. C

    Creating Calculations in Reports

    Hi plog, I've upadted the expression, however I'm receiving an error message stating that the expression you entered contains an invalid syntax. This is the expression TotalOutstanding: Sum(IIf([Project!WonLost]) Not 'Won' And Not 'Lost',[ContributionValue],0))
  4. C

    Creating Calculations in Reports

    I'm almost there, just the final expression isn't working. It doesn't display any totals when I run the query, they're all £0.00. I've attached a snapshot to show you where I'm up in the query, hope this helps? This is the expression that isn't giving me the correct data. Sum(IIf(Not 'Won'...
  5. C

    Creating Calculations in Reports

    Apologies, what do you need from me?
  6. C

    Creating Calculations in Reports

    I've tried to total the won and the lost together but I get an error stating that subquiers cannot be included in the expression?
  7. C

    Creating Calculations in Reports

    I've done it! Superb thank you. If I wanted to see what was outstadning, so Won + Lost then minus that off the total QuoteValue, how would I do that. Would I be able to use the same formula but just use 'Null', or would that look for the text Null in the field? Or, could I create another...
  8. C

    Creating Calculations in Reports

    Hi plog, Thanks for your response, I've used the Totals function within the query and managed to total all the quote value for each customer. Would I also include the formula you providedin your comment in the query aswell? Would this mean also that I would have to include the Won/Lost field...
  9. C

    Creating Calculations in Reports

    Hi All, I've created a report that shows quotation values for each of our customer. I want the report to be a summary rather than show a line by line figure. So I've grouped by Customer and then created a =Sum(
  10. C

    Checkboxes showing on report (Print Preview)

    Morning, I've created a report to show details of sales that are not booked in with our production. On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name. There's nothing in my...
  11. C

    Creating a lookup

    Hi, I'm really annoyed that Ijust typed my last post then solved it (sod's law) I was missing the frmProjectDetails from the start of the string, so it was working when I used it in the form but not finding the contact when I used it through frmProjectDetails. the expression now reads...
  12. C

    Creating a lookup

    Hi, Thank you for your responses, the solution worked for me. :D ____________________________________________________________ I now have a separate issue which is related to the same combo box as mentioned in my original thread. The text box which I created to show the phone number...
  13. C

    Creating a lookup

    Good afternoon, I want to create a text box within a form that automatically populates a contact number based on a selection from a combo box, also in the same form. For example, I have a Bidders Table (tblTenders), this form includes information regarding the Tendor like the company name and...
  14. C

    Accessing a split database from home

    Minty, Thanks very much! I've set up VPN and made sure the MSAccessBE is stored on a network drive. Many thanks, Chris. :D
  15. C

    Accessing a split database from home

    Good morning, Simple question really! Is it possible to access a split database where the back end is held on the works server from home? Thanks, Chris
  16. C

    Reasoning behind TWO combo boxes for the same field?

    Good morning, I've been asked to take a look at a database to look for areas which could be improved. It's not a database I've built myself so I've started by taking a 'walk-through' of the system to see how it works. What I did notice amongst other things which confused me a little was that...
  17. C

    Creating a batch file

    Hi JHB, Thanks for your reply, I managed to find a neat tutorial that explained how to create a batch file and implement it into what I was trying to achieve. Thanks, Chris.
  18. C

    Creating a batch file

    Hi All, I want to create a batch file that will be used in a RunApp macro command to open up another database. Can somebody explain how I do this, or point me in the direction of a thread? Thanks, Chris,
  19. C

    Setting up Outlook Reminders

    Hi, Is there a way to set up reminders/appointments in Outlook by using a command button/macro in access. So when we enter a date in a form, say a 'Next Review Date' - we have the ability to select a button which says 'Set Reminder' - this will then open up Outlook and ask us to complete the...
  20. C

    Unable to find parameters

    Thanks for all the responses. I've located the issue - it was a problem with my Child Records - it was pointing to a field in an old table that was deleted, that had the field name 'ID'. I've updated it to include the new 'ProjectID' which has resolved the issue. Thank you.
Back
Top Bottom