Partager via

SELECT-запросы в Access 2007 или Как сделать выборку и вывод значений по многозначному полю.

  • Article

??????????, ???? ??????: ???? ????? ?? - ???? ????? ??????????? ? Access 2007 ? Sharepoint-??????? ?????? ? ??????? ?? ???????. ??????? smb_deployment ???????? ? ????, ????? ??????, ??????? ? ????????? [customer name] ? [presale name], ???? ???????: ???????? ????????? ? ??? ??????????????(???) ??????????(??); ??? ???? ???? [presale name] ????????????, ?? ???? ????? ????????? ? ???? ?????? ?????? ????? (??? ??? ???????? ? ?????????? ????? ???????????? ????????? ???????) ? ????? "?????????????"  ???????????? ? ID ?? ??????? [User Information List], ?????????? ? ???? ?????? ??? ???? ????????????? ??????? ???? sharepoint; ??? ????????????? ?????????? ?? ??????? ? ???? ??????????? ??? ??????????? ???? ???????, ??????? ????? ???????????? ?????? ?? ??, ????????? ??? ???? SQL-??????? - ??????????, ??? ? ???? ??????? ???? ??????, ??? ????? ????????? SELECT ????? ???????, ????? ??? ????? ?????? ?? ??????? ???????????? ???? ?????.

??????? ???????, ??????, ???? ?????????? ?? ???, ??? ???????, ? ?????? ???????? ??????, ??????? ? ????????? - ??????? ?? ?????? ????????? ? ???? ?????? ?? ???? Sharepoint ?????? ?? ??????? ? ??????????? ???????? ???????????, ?????????? ?????????? ? ?????? ??????? ?? ???.

????? ????????? ??? ???????? ?? ???????? ? Access 2007 ? ?????????? ???? ? ??????, ????????????? ??????? ??????? ??? ??? ?????? ???????:

SELECT smb_deployment.[Customer name], smb_deployment.[Presale name] FROM [User Information List] INNER JOIN smb_deployment ON [User Information List].ID = smb_deployment.[Presale name].Value;

? ????? ?????? ???? ?????? - ??? ?????? ???????????, ??????? ????? ????????? ? ????? ?? SELECT, ??????? ? ????? ??????????????? ??????????? recordset ??? ???????? ? ??????? ptrreportgen, ??????? ?????? ??????? ????? ????? ?????: https://www.ljzsoft.com/index.htm?PTRPT