Microsoft Access áàçà äàííûõ îôèöåðîâ - ÐÓÑÑÊÈÉ ÈÍÂÀËÈÄ
Microsoft Access áàçà äàííûõ ïðîèçâîäåíèé, ïåðåâîäîâ, óâîëüíåíèé è.ò.ä. îôèöåðîâ, êëàññíûõ ÷èíîâíèêîâ, êàâàëåðîâ îðäåíîâ...
Áîëüøèíñòâî èç ñòðàíèö ÐÓÑÑÊÈÉ ÈÍÂÀËÈÄ (ñîäåðæèò ãîäû 1834, 1841, 1848, 1854, 1855, 1856) è ÑÏÁ ÂÅÄÎÌÎÑÒÈ (ãîäû 1799, 1809, 1810
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #29 àâãóñòà 2015 17:57 --- Mark Conrad
Tacoma, Washington | | |
| aklos Ïî÷åòíûé ó÷àñòíèê
Ñîîáùåíèé: 120 Íà ñàéòå ñ 2014 ã. Ðåéòèíã: 70 | Ââåðõ #22 äåêàáðÿ 2015 0:07 22 äåêàáðÿ 2015 0:08 Mark ConradÌàðê, ñïàñèáî áîëüøîå çà áàçó. Íà âñÿêèé ñëó÷àé ïðèâîæó êîä çàïðîñà, êîòîðûé ïîçâîëÿåò îïòèìèçèðîâàòü ïîèñê, à òàêæå ñîåäèíÿåò ðåçóëüòàòû ñî ñëîâàðåì ñîêðàùåíèé, ìîæåò áûòü èìååò ñìûñë äîáàâèòü â áàçó? [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] | | |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #28 àïðåëÿ 2018 15:32 2018 âîçîáíîâëåíèå è äîïîëíåíèÿ - Âûñî÷àéøèå ïðèêàçè 1801, 1806, 1820, 1825, 1830, 1845, 1836, Ðóññêèé Èíâàëèä 1853, 1852, 1857, ïîëîâûå èñòîðèè, è äðóãèå... ÍÎÂÛÅ ÑÑÛËÊÈ ÂÍÓÇÓ Microsoft Access áàçà äàííûõ ïðîèçâîäåíèé, ïåðåâîäîâ, óâîëüíåíèé è.ò.ä. îôèöåðîâ, êëàññíûõ ÷èíîâíèêîâ, êàâàëåðîâ îðäåíîâ... Áîëüøèíñòâî èç ñòðàíèö ÐÓÑÑÊÈÉ ÈÍÂÀËÈÄ (ñîäåðæèò ãîäû 1834, 1841, 1848, 1854, 1855, 1856) è ÑÏÁ ÂÅÄÎÌÎÑÒÈ (ãîäû 1799, 1809, 1810, 1811, 1812, 1813, 1814). Äðóãèå èñòî÷íèêè: Àäðåñ-Êàëåíäàðè 1854, 1888, Íåêðîëîãè Ñàéòîâà, ïîëêîâûå èñòîðèè, ñïèñêè îôèöåðàì, ñïèñêè êàâàëåðîâ, è.ò.ä.) Ñåé÷àñ (2018) ñîäåðæèò áîëåå 1,200,000 ëèíèé çàïèñåé.  ëàòèíñêèõ áóêâàõ. Ññûëêè: Óñëîâíûå çíàêè è ñîêðàùåíèÿ: http://www.mediafire.com/file/i0gbxz6367k8579/Abbr-Eng.mdb (íà ïðèìåð - 8110312 = 12 Ìàðòà 1811; prv = perevoditsya = ïåðåâîäèòñÿ; art = artilleriya = àðòèëëåðèÿ...) Èñòî÷íèêè: http://www.mediafire.com/file/...sNotes.mdbÁàçà äàííûõ (159MB): http://www.mediafire.com/file/hueo046yefek5a8/BIGCurrent.mdb --- Mark Conrad
Tacoma, Washington | | |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #28 àïðåëÿ 2018 15:36 28 àïðåëÿ 2018 15:37 Aklos,
Ñïàñèáî, ïîçâîëüòå ìåíÿ ðàáîòàòü ñ ýòèì. ß íå ýêñïåðò ñ êîäîì, Access Report, Query...
Íî õî÷ó ïîëüçîâàòüñÿ âàøèì êîäîì çàïðîñà! --- Mark Conrad
Tacoma, Washington | | |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #24 àïðåëÿ 2021 4:15 --- Mark Conrad
Tacoma, Washington | | Ëàéê (5) |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #24 íîÿáðÿ 2021 8:38 --- Mark Conrad
Tacoma, Washington | | Ëàéê (2) |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #4 àïðåëÿ 2022 5:55 4 àïðåëÿ 2022 5:59 --- Mark Conrad
Tacoma, Washington | | Ëàéê (2) |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #21 àâãóñòà 2022 2:20 --- Mark Conrad
Tacoma, Washington | | Ëàéê (2) |
| Mark Conrad Ó÷àñòíèê
Tacoma Ñîîáùåíèé: 60 Íà ñàéòå ñ 2006 ã. Ðåéòèíã: 101 | Ââåðõ #8 ÿíâàðÿ 2023 6:55 --- Mark Conrad
Tacoma, Washington | | Ëàéê (1) |
| Kolob-07 Äîëãîæèòåëü ôîðóìà
Ñàíêò-Ïåòåðáóðã Ñîîáùåíèé: 5468 Íà ñàéòå ñ 2008 ã. Ðåéòèíã: 4043 | Ââåðõ #8 ÿíâàðÿ 2023 21:34 Mark Conrad Ñïàñèáî çà Âàøó ðàáîòó, áëàãîäàðÿ Âàøèì ìàòåðèàëàì êîå-êàêèå ññûëêè óäàëîñü íàéòè.
Ìåíÿ èíòåðåñóþò Áàðõàòîâû. Â Âàøèõ ìàòåðèàëàõ åñòü ñëåäóþùèå ññûëêè:
RI149-135 8490620 èç ÑÏá â Í.Íîâãîðîä RI150-136 8500621 â ÑÏá èç Êèåâà
Êàê ÿ ïîíèìàþ, ýòî Âûñî÷àéøèå ïðèêàçû. Íî â ýòèõ ïðèêàçàõ íåò Áàðõàòîâûõ.  ïåðâîì - Áàðêàëîâ, âî âòîðîì - Áàðêîâ. Íåò íè÷åãî ïðî Í.Íîâãîðîä è Êèåâ. Ýòî îøèáêà â Âàøèõ ìàòåðèàëàõ èëè íàäî ÷òî-òî äðóãîå ñìîòðåòü?
Ñ óâàæåíèåì. | | |
|