Can I use right and left functions in queries??

[marlun]

Hi! I have a query thats selects objects, with long serielnumbers. I want the query to select the objects with similar first 8 characters. How do write that? Now I have the following command in the criteriabox: Left([Forms]![frmSök]![Text14],8)

Does anyone know how to solve this

Thanks

 

[Trendsetter]

If you want to select a serial number from the list and list all those that match your selection then:
The query column would have your Left() statement set against the serial Number similar to
Name - ToFind:Left([SerialNumber], 8)
Criteria - Like [Forms]![frmSök]![Text14] & "*"
This takes the contents of Text14 and then compares the serial number entries with the entry.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[danvlas]

One remark:
ToFind: Trim(Left([SerialNumber] & " ", 8))

Add 8 spaces to the right of SerialNumber, just in case Serial Number has less than 8 characters. And that will save you from error messages.

HTH




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[marlun]

Hi again. I'm not sure I understand.
I have a form where I select a serialnumber in a combobox. It vcan look like 4-475-12312456, where 4-475-12 is similar in many serialnumbers. So when I select a serialnumber in the combobox and then presses a button I want it to show all the "products" with 4-475-12 in its serailnumber in a listbox.

Maybe that's how you thought I meant, but I'm not sure how to write it.

 

[marlun]

Is anyone there. Would appreciate any help with this.

 

[marlun]

I have tried following:
Field: ToFind: Trim(Left([tblLager]![ProdSN] & " ",8))
Criteria: Like [Forms]![frmSök]![Text14] & "*"

This doesn't give me any result. The format on serialnumber is text. Does that make any differance.

 

[danvlas]

The condition in your query should be something like:

Like "'" & Trim(Left(Forms!YourForm!YourCombo & " ", 8) & "*'"

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[marlun]

Thanks danvlas, that worked like a charm.

/marlun