Recent content by murray83

  1. M

    Solved find missing date gaps

    Sorry for the lack of tables again, must remember to add them back if i split em. but yes works a charm, again thanks :)
  2. M

    Solved find missing date gaps

    i know solved but have one last question in this regard could the query you made, be altered also to look at dates missing based on today's date as I'm a bit behind in work and haven't been updating it on time, but still says missing only up to 21/6/20 but today's the 3/7/20 and i haven't...
  3. M

    Solved find missing date gaps

    and it looks epic
  4. M

    Solved find missing date gaps

    sir that is a very elegant solution, much better than mine, thank you and to all who put in there ideas
  5. M

    Solved find missing date gaps

    SELECT DISTINCT Main.Dt, DtChecker.Dt FROM Main RIGHT JOIN DtChecker ON Main.Dt = DtChecker.Dt WHERE Main.Dt Is Null ORDER BY Main.Dt; works and shows me the missing dates as seen here
  6. M

    Solved find missing date gaps

    oopss let me re attach the tables, sorry query working on is Query 1
  7. M

    Solved find missing date gaps

    ok but like you will have to read it on my phone on break as looks like blocked on works PC, boo
  8. M

    Solved find missing date gaps

    OK, but again how would that work ? sorry if im being daft see current DB, but the pdfs wont open sorry as on shared drive here at work
  9. M

    Solved find missing date gaps

    so have a front end which is just used to find and open a PDF file, bit quicker and better looking then searching through file upon file. but have come upon a question that I'm sure can be answered by you smart lot, have searched here but didn't find anything on the subject. but what i would...
  10. M

    Solved If a record is null

    i have read it at least three times and im not sure i understand would you mind showing what you mean just use my previous attached db
  11. M

    Solved If a record is null

    sorry i have read that one again, so you would have an extra text box which had "NO IMAGE" also for current code see attached
  12. M

    Solved If a record is null

    but one last thing, if i put in the coverimage part of the table "NoImage", which is the name of the image in the gallery for when i have no image yet, for the rest of my records all it shows is the NoImage even if i had an image, why ??
  13. M

    Solved If a record is null

    smart and done try half life
  14. M

    Solved If a record is null

    I did and thanks for the Nz idea
  15. M

    Solved If a record is null

    like this Private Sub cmbWho_AfterUpdate() Me.txtPlatform = DLookup("[Platform]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Platform Me.txtYear = DLookup("[Released]", "[T_Data]", "[ID] = " & Me.[cmbWho]) 'inputs Release Year Me.txtRegion =...
Top Bottom