Recent content by jack555

  1. J

    Solved Met or Not Met - Group By with conditions

    Exactly what I was looking for. Always you are solving the problems in a breeze. You are a star.
  2. J

    Solved Met or Not Met - Group By with conditions

    Sorry, edited the mistakes in question. Please check now.
  3. J

    Solved Temporary Table in Shared Front End

    I did as per your second advice. bound the form to the destination table. The records having the status "draft" until clicking the "save" button. So excluding the records with the draft flags for other purposes. Now successfully achieved the intended result without any issues. thank you...
  4. J

    Solved Met or Not Met - Group By with conditions

    Having a scenario where to auditors review and score different questions under few categories. I would like to mark the category as per the below criteria. if any of the questions in a particular category is "Not Complaint" then the category is "not compliant". If all the questions in the...
  5. J

    Solved Temporary Table in Shared Front End

    I agree with this. However, there is a challenge to implement individual copies for each user. Users float in every department and they always not copying the front end to their location. I will try to implement your advice, but need a workaround as well.
  6. J

    Solved Temporary Table in Shared Front End

    It's a survey table. user will answer certain questions and at the end of the survey, the value stored in the temp table should be transferred to the original. I made this to avoid inserting an incomplete survey in the original table. the reason it is not unbound is, there is an option group...
  7. J

    Solved Temporary Table in Shared Front End

    I use a temporary table to store values from the form and when the form closes, transfer temp data to another table and clear the temp table. This works fine if one user working on it. If multiple users working on the same front end, then throws a tricky scenario. How to solve this scenario...
  8. J

    DSum/DCount - Number of Unique records

    Exactly. my problem solved.
  9. J

    DSum/DCount - Number of Unique records

    This counts all the records of Data.Category. I wish Category should be counted only once for each group of Data.ItemName. Suggestion by @June7 works fine. out of curiosity, I am thinking about how to make this work in a single query.
  10. J

    DSum/DCount - Number of Unique records

    Yes, this solves my problem. Thank you very much. PS: updated the question to correct wrong info about "snack"
  11. J

    DSum/DCount - Number of Unique records

    I tried crosstab and total query without success. I could able to produce the total number of records, not the occurrences of category. I might be doing something wrong.
  12. J

    DSum/DCount - Number of Unique records

    I would like to generate the number of category occurrences in a particular month for the below example table. I think it can be done via DSUM/DCOUNT but couldn't able to achieve. Please help. Category ItemName Month Fruits Apple 2021-08 Fruits Orange 2021-08 Veg Chilli 2021-08 Veg...
  13. J

    Separate emails to multiple recipients with only items due on them

    Could you please advise at least how to send an email for each record? sorry I am too naive in executing the wonderful ideas proposed.
  14. J

    Separate emails to multiple recipients with only items due on them

    Thank you for the inputs. I will try these steps and resources and come back if anything is required. My VBA skills make this overwhelming. I will attempt to solve it.
  15. J

    Separate emails to multiple recipients with only items due on them

    Looked at this; seems more advanced level for me. My concern is a simple task. There are certain items due on each user every month. These due items are already filtered and available as a query. Now, how to send reminder emails to each user with the items only due for them? ID Task User Due...
Top Bottom