Finding data based on the last digit of a field.

[Hegnor]

Hello.

I work with a database that will help me and keep track of when my vehicle shall at eu-control .. What I want the database to do.

I enter the registration number license plate ex. BP62071

In Norway the last digit of the license plate tells me how months car should in to eu-control.
Then I want it to automatically add that this car should on eu-control in January. in a feld caled eu-control

if the last number is 2 it should have been at eu-control in February

can anyone help me with how I do this?



tell you if there is anything you do not understand.

thanks for the help

[June7]

Extract the last digit with:

Right([fieldname],1)

In query:

SELECT *, Right([fieldname],1) AS EU_Control FROM tablename;

[pbaldy]

No eu-control in Oct-Dec? If there will be a 2-digit code at the end (ie 11), you'll need to come up with another method.

[Hegnor]

It's like this
Janurary 1
February 2
March 3
April 4
May 5
June 6
July is no eu-control
August 8
September 9
October 0
December is no eu-control

I can use it june7 suggest

[June7]

November also no eu-control?

[Hegnor]

No november is 7

[Hegnor]

I'm pretty new so is there any chance that you or someone can help me and put this up so that work?

[June7]

So what will work? What do you want to do?

I suggested a query. Apply filter criteria to find records for any particular month.

[Hegnor]

Mente du: Jeg skal forklare hvordan jeg har tenkt at dette skal fungere.. Jeg vil kunne registrere kjøretøy via et skjema. Skjema_kjøretøy: Lisens plate Navnt på kjøretøy Eu-kontroll (denne ønsker jeg at komme automatisk ut fra det siste tallet fra licenc plate) En knapp som resetter eu-control 2 år fram i tid. skjønner du hva jeg mener?
I'll explain how I intend that this should work ..

I want to register vehicle via a form.

form_vehicle :

License plate
name on vehicles
Eu-control (this I want to come automatically from the last number of licenc plate)

A button that resets the eu-control two years ahead.

you know what I mean?

[June7]

Two years ahead of what?

Today is November 4, 2014. If the eu_control is for February, do you want to save February 1, 2016?

This gets a little complicated because the eu_control does not correspond directly to a month number for all months.

Me!datefieldname = IIf(Right([licensefieldname],1)=0,10, Choose(Right([licensefieldname],1), 1, 2, 3, 4, 5, 6, 11, 8, 9)) & "/1/" & Year(Date()) + 2