Access Queries

Anonymous
2025-01-27T08:46:50+00:00

Morning, I have got a problem with Queries on my computer running Windows 11.

I explain: I would like that, every time, when I want to add products on my list to be bought, the query shows me if this or these products are seaseonable.

I tried many times but unsuccessfully! Please see attached relations between tables.

I don't know SQL at all.
Many thanks for your help.
Regards,

CM

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

45 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-28T14:57:11+00:00

    What does that process involve? Are you manually checking them to indicating that they are seasonal? Are you selecting only seasonal products for some use?

    What I want each month is to have a request where all the seasonal products pop up in order to cook accordingly with the products of season. I.e in January, I know all these products but I don't know how to get them automatically when I choose a specific month. Not easy to explain as I don't know Access very well! Do you neeed anything else to further understand?

    Was this answer helpful?

    0 comments
  2. ScottGem 68,840 Reputation points Volunteer Moderator
    2025-01-28T13:48:01+00:00

    Yes please tell me how to implement that solution, as I am just using Access for days and obviously don't know much!

    Again, did you reread my initial response? Do you have any SPECIFIC questions about how to implement it.

    Was this answer helpful?

    0 comments
  3. George Hepworth 23,120 Reputation points Volunteer Moderator
    2025-01-28T13:40:41+00:00

    Your question was, "But every month, I'll have to select manually every seasonal product."

    I wasn't asking which table that is in, I was asking for the rules about selecting seasonal products. What does that process involve? Are you manually checking them to indicating that they are seasonal? Are you selecting only seasonal products for some use?

    Scott's description of a form and controls is appropriate for selecting products which have been designated a seasonal. What we need to understand is the business purpose of "Selecting products".

    Was this answer helpful?

    0 comments
  4. Anonymous
    2025-01-28T13:35:43+00:00

    Yes please tell me how to implement that solution, as I am just using Access for days and obviously don't know much!

    Was this answer helpful?

    0 comments
  5. Anonymous
    2025-01-28T13:33:37+00:00

    I think the best place is in "Products" table?

    Was this answer helpful?

    0 comments