Search results

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

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...

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

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...

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

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

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...

Thank you, that worked perfectly, much appreciated.

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

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...

Its not elegant but I've found a way to complete my objective. Thanks for the 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...

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

Thanks for your help. I've done as you've suggested but think I've made a mistake somewhere as it's not giving the expected results. I've attached a screenshot of the two queries and that of the outcome. Can you advise where I've gone wrong? Access isn't my strong point and very much struggle...

Whoops, sorry

Thank you, unfortunately it didn't like that, received an error (attached). Had this problem in the past and a user on here recommended the DLookUp. Any other suggestions?

I have a crosstab query which is currently grouping the data by year (see attached screenshot). It pulls data based on a DLookUp in another table (screen shot attached). The dates in the table will always be input as a complete 12 month range. This range can start anytime in the year and will...

Wow, thank you so much, that worked perfectly.

Thanks, how would I do this?

Hello all. In need of your assistance please. I've got a crosstab query where I want to pull the date start and end parameters from a table (TAQDate) however keep receiving an SQL statement error because it contains ambiguous outer joins. Screenshot of the query attached. I wanted to have the...