Search results

  1. C

    Problem with inner joins

    This could have been when I've needed to delete some of the data in order to send it! Again, the set up of the database is poor and not something I've ever been involved with. It works for 95% of what we do, however in the near future could do with some major work. However, it seems that the...
  2. C

    Problem with inner joins

    Apologies, this is what it looks like now. I've read your previous message back... SELECT Phase.[Phase ID], Product.[% Done], (IIf([Product].[% Done]=100,1,0)) AS Done FROM Phase INNER JOIN Product ON Phase.[Phase ID] = Product.[Phase ID]; Is this the point where I need to join it back to my...
  3. C

    Problem with inner joins

    Ok, so I've done it in designer and go it to show all the phases that are complete. How do I now join this on to my original query? SELECT Phase.[Phase ID], Product.[% Done] FROM Phase INNER JOIN Product ON Phase.[Phase ID] = Product.[Phase ID] WHERE (((Product.[% Done])=100));
  4. C

    Problem with inner joins

    Giving me an error? Did you manage to get access to the database I attached in my previous post?
  5. C

    Problem with inner joins

    I've attached a copy of the database for your reference. The query is being set up in a front end copy though, will this matter?
  6. C

    Problem with inner joins

    namliam, This is exaclty what I want - it's just getting to that stage. I'm sorry that I'm not educated well enough on this. This is my reason for coming to the forum to try to understand and learn this kinds of issues. I'll try to attach a copy of the database for you to take a look. Chris.
  7. C

    Problem with inner joins

    This is what it looks like when I run it without using the condition 100% done. It gives me all the jobs and the total cost of materials. Which is great, however I want to filter out jobs that are completed ONLY. Which is the reason for trying to use the 100% field.
  8. C

    Problem with inner joins

    I can totally agree that there are some major design issues, As I mentioned I'm not an expert on this and it was a database that was designed long before I joined the company. If it can't be done, that's fine I'll look at an alternative, I just thought it'd be easier to build a report where the...
  9. C

    Problem with inner joins

    Hi, I'm working on a company database that was already in place before I came here, otherwise there would have been no way I would have used special characters etc. I can only work with what I have in front of me, which does seem a little difficult. I've tried the code you sent and it says...
  10. C

    Problem with inner joins

    Hi, I did think the explination was a little sketchy! I do apologie. I've attached a screenshot showing the query and how it set up and how I want it to work. I've also include the SQL Statement below... SELECT [Materials Requested].[Materials Requested ID], [Materials Requested].[Job No]...
  11. C

    Problem with inner joins

    Good afternoon, I'm really struggling with my query and I hope I can explain well enough for you to be able to help me. I've been asked to product a report that shows our 'Material Allowance' was for all Jobs where, the Job is complete. (We have a field called '% Done' and when it shows 100...
  12. C

    Creating a query that will merge various fields into one field

    Thanks Paul, done the trick perfectly! :D
  13. C

    Creating a query that will merge various fields into one field

    Hi, I'm looking for a way to merge various fields from a table into just one using a query. The purpose will be for easier copying and pasting in to an email. So we have a table to stores information such as Site Contact, Address 1, Address 2, Address 3, Postcode etc. I want to be able to...
  14. C

    A few questions regarding a new database...

    gemma-the-husky, I think I understand what you mean now. So I've created a new table to accomadate 4 fitters: tblFittersOrders (not quite sure on the choice of name): FitterOrderID Fitter1 Fitter2 Fitter3 Fitter4 Can you see anything else that I would need to include in that table? Thanks,
  15. C

    A few questions regarding a new database...

    Hi gemma-the-husky, Thanks for your reply. I've not had any experience with SQL so would this cause a problem. Is that the only work-around for me to be able to add more than 1 fitter?
  16. C

    A few questions regarding a new database...

    Hi, To add to my original post. The fitters wqould link via the FitterID. So how would I be able to include more fitters in the table? Even if I set up Fitter 1,2,3,4 in their own respective fields I would only be able to use a combo box to store the text back in the table. I wouldn't be able...
  17. C

    A few questions regarding a new database...

    Hi All, I'm designing a new database that will be used in the company that I work for and hopefully assist with our installations department. The purpose of the database will be to record what we call 'F Notes', which is basically a Purchase Order, only that we use a unqiue number that begins...
  18. C

    Creating Calculations in Reports

    That's the one! Thanks a lot! Now I can put it straight into the report. I've learnt a lot and I appreciate your patience. Many thanks, Chris.
  19. C

    Creating Calculations in Reports

    Won or Lost or Null There is no Default Value
  20. C

    Creating Calculations in Reports

    It's still show zero values (£0.00) See screenshots....
Back
Top Bottom