Backend Geeks

• M

  How do i query large datasets based on value of one column with several columns that differ on only two columns
  • Mustapha Aliyu

  4
  4
  Posts
  192
  Views

  R

  @Mustapha-Aliyu This query should work

  SELECT Table1.houseid, Table1.flatnumber, Table1.roomnumber, Max(Table1.payscale) AS [Max Of payscale] FROM Table1 GROUP BY Table1.houseid, Table1.flatnumber, Table1.roomnumber;

  But It won't return tenant number. I'm trying to get that too. I'll let you know if I could get it!

• M

  Grouping Rows
  • Mustapha Aliyu

  2
  2
  Posts
  183
  Views

  R

  You can use filters or sort by order to group rows vertically as shown in this gif - http://i.imgur.com/rZWI5fA.gif
  But I'm not sure if you can get all the users horizontally in the same row unless you write a custom script.

• M

  Automate Sharepoint login in ms access
  • Mustapha Aliyu

  9
  9
  Posts
  1226
  Views

  R

  Can you share your SharePoint server details in private? It's really hard to say what's the issue without having a look at the SharePoint server.

• G

  FB Bot coding on Cloud9
  help bot facebook • • gameboyll

  5
  5
  Posts
  723
  Views

  G

  That did it! I appreciate your help and I'm sorry I'm quite new to coding, I wasn't sure how to define request. Thank you so much again!!