Sorting with letters

[awojciehowski]

Maybe this will help...I have multiple queries working on this form.

SELECT [Add New Inventory Entry and Inventory Details].LedgerNumber, [Add New Inventory Entry and Inventory Details].SPDCaseNumber, [Add New Inventory Entry and Inventory Details].OfficerID, [Add New Inventory Entry and Inventory Details].ReceivedDate, [Add New Inventory Entry and Inventory Details].Location, Entrys.Comment, [Add New Inventory Entry and Inventory Details].ItemNumber, [Add New Inventory Entry and Inventory Details].EvidenceName, [Add New Inventory Entry and Inventory Details].Quantity, [Add New Inventory Entry and Inventory Details].LedgerID, [Add New Inventory Entry and Inventory Details].Notes, [Add New Inventory Entry and Inventory Details].[EvidenceDisposed?], Entrys.DispoDate, Entrys.DispositionMethod, Entrys.DispoCaseNumber, Entrys.Keep
FROM Entrys INNER JOIN [Add New Inventory Entry and Inventory Details] ON Entrys.LedgerID = [Add New Inventory Entry and Inventory Details].LedgerID;

However, I understand that my mistake may be related to the "Print Current Record" button...what is the problem for the sub form of the list of Item #'s still not showing to be sorted correctly?

[NeoPa]

Well, what can I say?

This looks nothing like what I posted.

The techniques I used are not here and it's displayed as an enormous dump of characters. I've tidied it up once to work with, I don't want to do it again thank you.

I'm not sure what you want from me. This is something totally different from what I suggested. How can I help if you choose to ignore what I suggest?

I admit to being a little confused.

[awojciehowski]

NeoPa-

I am sorry to offend you...it appears that you are quite upset about my last post. I am not well versed in SQL or Access thus the posting for help. I was reviewing the queries that were associated with the form that I posted a screen shot of. I found that the "Print Current Form" had a seperate query and that is what I posted since the error as described above occurred when I clicked on the "Print Current Record" button.

I realize that you are a consumate contributor to this site and do apologize for my impotence regarding Access. However, if this is going to be resolving into a frustration for you and a curt response that is not needed then I thank you for your time and will drop the issue.

Anyone else willing to assist without the condensation?

[NeoPa]

To be honest Adam, I was more confused than upset. I'm equally confused that you should interpret my quite reasonable post as condescension.

I simply asked you to post back the SQL from the query I thought I was helping you with. This is not a task that requires any previous Access or SQL expertise. Your previous experience should have no bearing on this whatsoever.

I was at a loss (confused) and I had no idea how to respond when I saw your post. This seemed to be entirely unconnected with what I'd asked for. How does someone explain that you got it so wrong without sounding insulting - bearing in mind this was nothing to do with experience or lack thereof? You try. Maybe you could have found better words than I did.

I'm happy to respect your wishes though, whatever reason that may be for.

I can simply wish you good luck with your project.