Query to find any records that has a space

[Number11]

So i need to build a query to show any records within the field called MTest that begins with a space (data enter error)

I have this to fix it

UPDATE DataRequests SET DataRequests.MTest = Trim([MTest]);

but this runs on the complete table and is now slow,

so need to set the criteria just to update any that begins with a space

 

[Gasman]

WHERE LEFT(MTest,1) = " " ???

 

[jdraw]

@Number11
Please let us know if there is a speed change.
In your data entry validation, you may want to include the Trim function to do the space(s) removal before saving.

 

[Number11]

@Number11
Please let us know if there is a speed change.
In your data entry validation, you may want to include the Trim function to do the space(s) removal before saving.

how would i add this to the form please

after update?

 

[jdraw]

Before update. That's your last chance to edit/change anything before saving.

 

[The_Doc_Man]

Once the space is there, unless there is an index on the field, there will be little or no speed effect on having a WHERE clause. You have to visit each record anyway once you have it in a table and are using a query. You actually would do better (I think) in just trimming the field whether it needs it or not.