Access Gripes!!!!!!!

[kidrobot]

If this is already a post sorry. I just wanted to hear what your Access gripes are and what you think can/should be improved.

I have 2 gripes.

1. Count distinct doesn't work like it should

2. Having a list box as criteria is 10x harder than it should be.

 

[Rabbie]

How should Count distinct work in your opinion? Constructive criticism has more chance of being listened to and acted upon.

 

[kidrobot]

How should Count distinct work in your opinion? Constructive criticism has more chance of being listened to and acted upon.

It should work like it works in SQL server!!!!!!!

I'm not trying to change the world, I'm just venting.

 

[The_Doc_Man]

Here is a serious suggestion, though it might take a while to set it up.

Make an Access-only MDB by copying some relevant tables from your SQL server.

Copy the query that causes your problem to the Access-only database.

Run the queries side-by-side. See what you get. If you don't get the same answers from both, post the query here along with a screenshot of what you got from each database - the Access-only and the Access FE/SQL BE.

Perhaps one of us will see the problem. Instead, perhaps one of us will see that the issue should be escalated to MS for their consideration.

I don't claim to know the rules on MS SQL Server but there are those of us who do work with it and might have some advice.

 

[kidrobot]

Doc the issue I had has been resolved. The problem I had was counting the fields for 3 different columns. When I did this it gave me the same counts in every column. There was also an issue when I tried SUM DISTINCT, but again I don't need help, but thanks for the offer. I just wanted to vent some issues I've had with Access, since I'll probably never be using it again since my Internship is over with in a couple days!

 

[kidrobot]

One more. Changing the color of a button!!!!

ps. I know you can use a label as a button and format it like a button.