Recent content by KINGOFCHAOS17

  1. K

    SubForm using Crosstab Query (Dynamic Column Problem)

    Thank you. I can't see any design details for the Child0 subform, I was hoping to replicate this process with other similar data. I imported the subform Child0 into my form and tried linking on ID and CatalogID however I received the attached error. I can't see / don't understand what I'm doing...
  2. K

    SubForm using Crosstab Query (Dynamic Column Problem)

    Oh wow, that’s totally my mistake, sorry. I’d been working on reports all week and had them on the mind. I’m this scenario/requirement it’s a subform.
  3. K

    SubForm using Crosstab Query (Dynamic Column Problem)

    Thank you, I've tried applying this to a Form, however having problems with the data fields showing an error. What am I doing wrong?
  4. K

    SubForm using Crosstab Query (Dynamic Column Problem)

    Hello all. I'm trying to create a subreport linked by field [CatalogID] from a crosstab query. The columns of the query are dynamic and I'm struggling to get the subreport to function correctly when the data changes in field [Year]. I've attached screenshots of the crosstab query and of the data...
  5. K

    Solved Compare Queries

    Thank you!
  6. 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...
  7. K

    Solved MID Function

    Thank you, I modified it slightly and is working perfectly NSC: IIf([CAGE]="ABC12",Mid([PartNbr],1,4))
  8. 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...
  9. K

    Solved Weight Conversion

    Thank you, that worked perfectly. Much simpler than I was thinking.
  10. 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...
  11. 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.
  12. 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?
  13. 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...
  14. K

    Solved Grouping in Reports

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

    Solved Grouping in Reports

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