Microsoft Access база данных офицеров - РУССКИЙ ИНВАЛИД

[q]

Microsoft Access база данных производений, переводов, увольнений и.т.д. офицеров, классных чиновников, кавалеров орденов...

[/q]

[q]

SELECT Big.[Issue number], 1 & Left(Big.[Date of action],3) AS [Year], Right(Big.[Date of action],2) & "/" & Mid(Big.[Date of action],4,2) & "/" & 1 & Left(Big.[Date of action],3) AS Dt, Nz(br.meaning,Big.Branch) AS Branch, Nz(rnk.meaning,Big.[Rank (before action)]) AS Rank_before, Big.[Last name], Big.[Other names], Nz(un.meaning,Big.[Unit (before action)]) AS Unit_before, Nz(pos.meaning,Big.Position) AS [Position], Nz(act.meaning,Big.Action) AS [Action], Nz(res.meaning,Big.Reason) AS Reason, Nz(act2.meaning,Big.[After action status (1)]) AS Status_after1, Nz(act3.meaning,Big.[After action status (2)]) AS Status_after2, Big.[First names from other source]
FROM (((((((Big LEFT JOIN Abbreviations AS br ON Big.Branch = br.abbreviation) LEFT JOIN Abbreviations AS rnk ON Big.[Rank (before action)] = rnk.abbreviation) LEFT JOIN Abbreviations AS un ON Big.[Unit (before action)] = un.abbreviation) LEFT JOIN Abbreviations AS pos ON Big.Position = pos.abbreviation) LEFT JOIN Abbreviations AS act ON Big.Action = act.abbreviation) LEFT JOIN Abbreviations AS res ON Big.Reason = res.abbreviation) LEFT JOIN Abbreviations AS act2 ON Big.[After action status (1)] = act2.abbreviation) LEFT JOIN Abbreviations AS act3 ON Big.[After action status (2)] = act3.abbreviation
WHERE (((Big.[Last name]) Like [Введите первые буквы фамилии:] & "*"))
ORDER BY Big.[Last name], Big.[Date of action];

[/q]