User Profile

Collapse

Profile Sidebar

Collapse
iamsophie
iamsophie
Last Activity: Nov 20 '15, 11:50 AM
Joined: May 29 '15
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • iamsophie
    started a topic [SOLVED] SELECT TOP query not working
    in Access

    [SOLVED] SELECT TOP query not working

    Hi All,

    I have a form where the user can fill out different search criteria and find specific sales data in the database.

    I have 2 queries;
    a) finding colleagues' performance scores
    b) finding sales for specific campaigns and/or specific stores

    They both work perfectly, so I decided to also add a little modification next to these two basic queries:

    a) show me the top 5% best...
    See more | Go to post
    Last edited by iamsophie; Oct 21 '15, 09:39 AM.
    • iamsophie
      started a topic [SOLVED] Combine nested IIF and SELECT TOP
      in Access

      [SOLVED] Combine nested IIF and SELECT TOP

      Hi All,

      I'm working on a database which shows the performance of our field colleagues.

      I'm done with almost all functions, except for one.

      I have a search form where the user will be able to search colleagues based on different criteria. One of this goes like this:
      Show me the top..
      5%
      10%
      15%
      and an option button next to each.

      I need a query something like this:...
      See more | Go to post
      Last edited by iamsophie; Oct 9 '15, 02:23 PM. Reason: Problem solved
      • iamsophie
        replied to Query based on multiple criteria from form w/ between dates
        in Access
        Thanks for your help again!
        See more | Go to post

          Leave a comment:

        • iamsophie
          started a topic Query based on multiple criteria from form w/ between dates
          in Access

          Query based on multiple criteria from form w/ between dates

          Hi All,

          I have a form with multiple fields (e.g. exact date, store name, store type, coverage status etc.). The user can fill in any of them and then a query returns the results.

          Everything works perfectly, but when I try to put the between dates in as well in SQL view, it keeps returning an error message (Expression is typed in incorrectly.)

          I'm fairly new to Access and can't figure out how to include...
          See more | Go to post
          Last edited by zmbd; Jun 9 '15, 01:53 AM. Reason: [z{added code tag to second block of script}{stepped SQL}]
          • iamsophie
            replied to Queries based on forms (one OR multiple fields)
            in Access
            That's amazing, it works! Thanks so much! :)
            See more | Go to post

              Leave a comment:

            • iamsophie
              started a topic Queries based on forms (one OR multiple fields)
              in Access

              Queries based on forms (one OR multiple fields)

              Hi Everyone,

              I’m trying to create a database, which shows all of our campaign sales from Jan 2014. The database includes details like:
              - Campaign name
              - Campaign type
              - Product ID
              - Category
              - Exact Date
              - Month
              - Year
              - Total Sales
              - Incremental Sales
              - Uplift %
              - Etc.

              I have a form with multiple fields, where the user can enter any of...
              See more | Go to post
              Last edited by Rabbit; May 29 '15, 04:40 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
              No activity results to display
              Show More
              Working...