Query Question?

[serino]

I have query that pulls one field called "JobNumber" from a table. This field is a 8 digit number.

Is it possible to extract or un-join the first four digits and the last four digits and then put them into a new query? For example: Jobnumber [36089045] would then become new field1 [3608] and field2 would then become[9045].

 

[Remou]

You can use the Right and Left functions.

 

[easyit]

Yo could use the functions left and right as selection criteria in your query



EasyIT

"Do you think that’s air you're breathing?

 

[serino]

Thanks! for the direction, I will give those functions a try.