Recent content by KINGOFCHAOS17

  1. K

    Solved Compare Queries

    Thank you!
  2. K

    Solved Compare Queries

    Hi all. I'm trying to categorize order data and compare rush orders against previous order history. I've created two queries 'Rush' and 'Orders' to gather only the orders I'm interested in. What I'd like to do now is categorize each line in the 'Rush' query to determine if the ordered part has...
  3. K

    Solved MID Function

    Thank you, I modified it slightly and is working perfectly NSC: IIf([CAGE]="ABC12",Mid([PartNbr],1,4))
  4. K

    Solved MID Function

    Hello all. Need some assistance with using MID in query. I've been using the MID function to split out down the data in column 'PartNbr' this works fine for the most part, however is there a way to only invoke the MID function if column 'CAGE' shows ABC12? If there's a better function to use...
  5. K

    Solved Weight Conversion

    Thank you, that worked perfectly. Much simpler than I was thinking.
  6. K

    Solved Weight Conversion

    Hello All. I've got a simple table containing product data, one of the fields contains the weight and another contains what unit of measure has been used (either pounds or ounces), I'm trying to write a query that will convert the weight to kilograms but struggling with how to handle two...
  7. K

    Solved Format based Query

    Thank you ever so much, that worked like a charm and found multiple locations that didn't match the correct pattern.
  8. K

    Solved Format based Query

    Hey. I did read some stuff on that, but it made absolutely no sense what so ever. Can you assist further please?
  9. K

    Solved Format based Query

    Need some assistance with writing a query and honestly and I'm not even sure how to put this into words. I want the query to find records where the field isn't in a specific format. The field in question is for the location in the warehouse and has a specific alphanumeric format with an optional...
  10. K

    Solved Grouping in Reports

    Thank you, that worked perfectly, much appreciated.
  11. K

    Solved Grouping in Reports

    Hi. So the group would be created using field SNOW, how would I create the calculation?
  12. K

    Solved Grouping in Reports

    In need of some assistance with creating a report. I know what I want, but not sure where to begin. I've five fields in my table (see sample data) and I would like to group by field 'SNOW' and then check the status of field 'LINE STATUS'. So for example SNOW (or order) 1, 24, 200, and 338 at the...
  13. K

    Solved Crosstab Query Date Help

    Its not elegant but I've found a way to complete my objective. Thanks for the help.
  14. K

    Solved Crosstab Query Date Help

    Unfortunately the database resides on a server that's accessed via Remote Desktop which has the ability to export data between environments disabled. The best I can provide is screen shots as I've been doing. So the crosstab query I've constructed currently groups by the year and pulls the data...
  15. K

    Solved Crosstab Query Date Help

    Thanks for your follow up. So, I amended the first criteria as you suggested and received the same outcome. See attached screenshots. Any suggestions?
Top Bottom