Search results for query: *

Thanks, that is also a brilliantly simple solution. I guess I've been quite lucky in my previous experience to not have to find a solution to this problem. As I said in my original post, my first solution would have been to change the tables so they are correct to start with. Golom's reply...

That's perfect. If I'm reading it correctly, I take it the Trim$([FieldName] & "") = "" qualifier covers null and zero length text strings in one go? This may also prove quite useful. To start with, I just want to be able to produce a query showing the data we know to be correct. After that I...

I have been given the task of creating queries on a database where the data entry forms return an index number into a Text field, which should be joined to a reference table which uses a number field for the index. I know the simplest (and best) solution is to have the administrators change the...

Thanks for the replies, I presume then that I can create a query that returns all the data from the table and set the order property there, and use that as the record source instead of the table.

First off, I have tried searching but couldn't come up with an answer so I apologise if this has already been covered. I have a database in Microsoft Access 2000. A while ago as part of a data cleansing exercise I used a Make Table query to make a copy of the main data table, but the records...

Hi, First off, apologies if this should go in a different forum, the Tables forum seemed the best place to me. I am a rookie to Database development and have had to teach myself the majority of what I know so would appreciate tips if I have missed anything that seems obvious to a pro. Here's...