Search results

Does anyone have an idea? Is it 'acceptable' to sort by Val?

p.s. there is nothing entered in Order By and Order By On is set to No in the form properties sheet.

Yes, i have tested the query now and it does work fine so nothing wrong with it, but the report still fails to sort properly. I did try making another query of the above, and adding the ORDER BY clause in as you suggested and it still produced the same results. One strange thing, i think i've...

Hi Brian, have you gone on holiday yet? If so thanks for your help, hope you had a good time :D If not, i still can't get it working, this is my Query in SQL:- SELECT qselCustomerAreaSearch.Title, qselCustomerAreaSearch.[FirstName/Initial], qselCustomerAreaSearch.Surname...

Ok i've been trying it out...... In queries (except qselCustomerDetails) it works perfectly, and all is in the correct order with any text entries at the top, etc. In reports, when i've already added it to the query in which the report is based on, it appears to do nothing?? It's as if it...

Actually, when entered in qselCustomerDetails theres an error which says 'Data type mismatch in criteria expression'. This didn't happen in the other queries tested, and the field was ordered correctly.

Would it be best to enter it in the query which the report is based on, or the SQL Query/record source of the report itself?? I currently have 6 reports, using 4 different queries with the 'house/flat number' field, i.e. area search, town search, and street search. Three of the queries were...

I don't think i can attach the database, its already in use and has 1000's of customers in it, sorry :( Do i need to do it like this.... Make a new query and add the table that holds the 'house/flat number' field, then add the field to the query, then change to sql view and add the statement...

Oh i'm reeeeeeaaallllyyyy sorry! :o But i'm still learning (obviously) and i can't work out how to do it/where to put it :o :confused: Sorry!!! Erm, i have several reports, grouped by street name, and then ordered by the 'house/flat number' field. I know Pat is very busy, so i understand if...

Ok that sounds brilliant Pat, thanks a lot :D I'm really sorry, but where do i have to put the statement then? :o :o :o

Anybody know?? Thanks :)

Thanks for your replies, i think i have a problem, will it still work considering that there are a few (very small amount) of entries which use house names instead of numbers?? Also, as i said i'm still learning, i'm afraid im not too sure what to do with the statements :o Sorry :o Thanks...

Hi everyone, would anyone be able to help me out? I would like to ask what would be the best/easiest way to be able to sort a text field as numeric? I have a customer database, and the 'House/Flat Number' field is a text field as it has to contain letters aswell, i.e. 41b, etc, and in a very...

Ok thanks. Used naming conventions for tables, forms, queries, etc, aswell as field names, but not for controls yet :o

Thanks alot Roy!! :D That worked a treat!!!!!! :D I had to delete the 'cbo' part of 'me!cboNameOfYourCombo' aswell as put name of combo (obviously) but then it worked perfectly. Thanks again, thats brilliant! :cool:

Hi mate, thanks. Unfortunately i think its a bit over compicated for me. All i was trying to do is when you enter a customer surname that's not in the list, have the form (same form) go to a new record, so you can enter the customers full details (name, address, etc). It sounds simple, but i...

Anybody have anything else i can try? :( :confused: :(

Hi M8KWR, thanks for the help. I had only realised about the limit to list = yes thing about half an hour ago, so i tried it too, but it seems to be the same as yours, it either doesn't work at all or i get an error message :confused: Any more ideas? Thanks alotfor your help :)

Hi all, I apologize if this has been answered many times, but i couldn't find the answer when searching. It's probally pretty simple. I have a form with a combo box at the top used to find customers on the form. It is used to navigate to a customer and also check if a customer already has a...

Anybody? :(