Query to remove first 4 characters in table

[3Mark3]

Does anyone know how to setup this query? I'm trying to find out how to delete the first, say 5 characters. Example would be

Pre-qry
0001974668845

post-qry
74668845

 

[SkipVought]

Hi,

Right([YourField], Len([YourField])-5)

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[PHV]

Why not simply this ?
post-qry: Mid([Pre-qry],6)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886