Search results for query: *

I am running Access 2016 and receiving a file from an external system which lists average and max usage for each interface. The challenge is that the information is all listed in one field to include the usage in Kbps, Mbps, and Gbps and need to do a calculation in that field based on value...

Running Access 2016 and importing a .csv file from server, which contains equipment usage information. The usage information is provided in 15-minute intervals (collection) each day by ID and channel as shown in example. The example shows ID’s pf ACME 01 and ACME 02 and associated channels...

Hello, I am using Access 2016 and need some assistance with pulling a max value for field based on 30 days of daily files. I have a few hundred elements which are collected daily and appended to a access table (Daily Usage Files) and need to pull max value of peak utilization for each one ( 2...

I am using Excel 2016 and trying to figure out how to assign values to field combinations with a formula. Looking at status of equipment (Operation and Admin) Based on unique query there are 3 possible combinations:

I am running Access 2007 on windows 7 and need some assistance with matching up two files received every day since one is vertical and the other horizontal. File #1 (Areas listed as below) Account Area identifier Clarksville 86.32.46.1 Clarksville...

I am using Access 2007 on Windows 7 and have the following issue. I pulled data from our billing system and the phone number is in two fields and drops leading zeros if they exist in field PHSFX Example: Table - CustInfo Field 1 - PHPRFX - 720345 Field 2 - PHSFX - 35 (really should be 0035)...

I am using Access 2007 and have 3 tables to match on common field (email address) but it is not populated the same in each table Table #1 joe.smith@abc.com Table #2 joe.smith or could be joesmith Table #3 joe.smith@abc.com How do I assemble query to just match everything before the @ symbol...