Search results

  1. S

    Question about Max() Function And Group By

    (Access 2007) I have a table with 2 columns: 'Sample_Time' and 'num_of_messages'. the table contain around 400 records for each day. I want to make a query which will give me as output the time (date and time) and 'num_of_messages' where maximum 'num_of _messages' appear for every day (group by...
  2. S

    Question Problem to Import IP Address column from csv file

    I am doing a simple Auto import of multiple csv files from a folder, 2 of the columns that imported are filled with IP Addresses value. once I do the import and after checking the table I realize that the entire IP Addresses values are cut, for example the real value is 192.113.13.80 and in the...
Back
Top Bottom