andrewsw's Profile User Rating: *****

Reputation: 5219 Overlord
Group:
Moderators
Active Posts:
20,464 (17.79 per day)
Joined:
12-December 12
Profile Views:
156,501
Last Active:
User is online 10 minutes ago
Currently:
Searching...

Previous Fields

Country:
GB
OS Preference:
Windows
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
4425
Expert In:
VB.NET C# JS Python
Icon   andrewsw Giggity, Giggity, Goo!

Posts I've Made

  1. In Topic: Sorting not working for report

    Posted 5 Feb 2016

    You can read about it starting with these two articles:

    http://access.mvps.o...ookupfields.htm
    http://improvingsoft...ccess-are-evil/

    View Postkirnicko, on 06 February 2016 - 12:07 AM, said:

    But why would it sort on that if I've selected the nickname and ascending options??

    Are you expecting an application to always behave as you've told it to :dontgetit: :bigsmile: (or as Microsoft says it does).
  2. In Topic: Sorting not working for report

    Posted 5 Feb 2016

    If you've used the Lookup Wizard then it's probably sorting by the id/key number, rather than alphabetically. There is not much else anyone could say given the limited information.

    smart questions

    The Ten Commandments of Access:

    Quote

    2. Thou shalt never allow thy users to see or edit tables directly, but only through forms and thou shalt abhor the use of "Lookup Fields" which art the creation of the Evil One.
  3. In Topic: Send data between pivot

    Posted 5 Feb 2016

    You have received a number of responses. If you don't understand something about a response then ask further questions. Do not ignore them and re-post the same question, especially so if you are not adding any further information or clarification.
  4. In Topic: Sorting not working for report

    Posted 5 Feb 2016

    There cannot be a relationship between a text and a number field. We need more information to realise what the problem(s) might be.
  5. In Topic: Sorting not working for report

    Posted 5 Feb 2016

    Sorting, using ORDER BY, works. The data will be sorted in lexicographical order. If sorting doesn't appear to work then there is something unexpected about the data, or the way that sorting is used.

    You need to post some representative data that demonstrates the problem, with details of your query and perhaps a screenshot.

    (If sorting didn't work the universe would be tilted :whatsthat: )

My Information

Member Title:
Speak up, I'm wearing a towel
Age:
Age Unknown
Birthday:
Birthday Unknown
Gender:
Interests:
Fixing you
Programming Languages:
VB.NET, C#, Java, SQL, PHP, JavaScript, jQuery, HTML, CSS, Python, VBA, VB6, Regex

Contact Information

E-mail:
Private
Website URL:
Website URL  http://andrewg.comuf.com/

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    zorror Icon

    27 Jan 2016 - 03:56
    Thanks for fix with code tags.
  2. Photo

    livetrainstatus Icon

    13 Dec 2015 - 03:38
    Thanks for your help..help me to get the answer
  3. Photo

    BookMark Icon

    04 Sep 2015 - 16:36
    Thanks for the help, I appreciate it.
  4. Photo

    jeffindenver Icon

    29 Aug 2015 - 05:22
    Thanks for being so active and answering questions on the vb.net subforum.
  5. Photo

    andrewsw Icon

    15 Aug 2015 - 12:49
    You're welcome. You can press the green plus-button if a post has been helpful.
  6. Photo

    alexstrinda Icon

    15 Aug 2015 - 11:31
    Helped me to get to the right answer! Thanks!
  7. Photo

    matt4051 Icon

    23 Jul 2015 - 16:21
    Offers really good help, i am very appreciated that he took the time to check my work out
  8. Photo

    _KABOOSE_ Icon

    05 Jul 2015 - 12:28
    awesome
  9. Photo

    mbole87 Icon

    01 Apr 2015 - 00:58
    Andrewsw helps me second time, awesome.
  10. Photo

    farad Icon

    15 Nov 2014 - 16:34
    One of the best...
  11. Photo

    abdalraheem Icon

    31 Dec 2013 - 04:59
    Thanks
  12. Photo

    Michael26 Icon

    14 Nov 2013 - 04:21
    Boom, 2000 rep points :)
  13. Photo

    laytonsdad Icon

    21 Aug 2013 - 14:03
    Getting close to 1500 rep, you are a robot.
  14. Photo

    Flukeshot Icon

    14 Jul 2013 - 16:09
    1337 reputation points, truely elite!
  15. Photo

    Michael26 Icon

    09 Jun 2013 - 14:11
    Wow andrew, you're on fire this month
    82 reputation points, nice :)
  • (2 Pages)
  • +
  • 1
  • 2