Search results

I will remember that in case they do ask in future, I have put the missing quotation marks in now as well, Cheers, have a great weekend

Hi VbaInet, This has worked perfectly, I have used TYPE2: IIf([NEWBOX.CUSTOMER]=XD-0060,"ES140",[NEWBOX.TYPE]) and this gives me ES140 if the customer is XD-0060 or just whatever the original type is if the customer is not XD-0060 and just replaced the control on the report. For future...

Will do, Thanks again

Will do and thanks for your time, it is much appreciated

I see what you mean but I don't want both TYPES to print on the report Just either the original or if the custumer = XD-0060 then the other type, if I put the new control on the report and the customer doesn't = XD-0060 Won't the value be blank ? or am i missing something Sorry if I come...

But that just creates a new field that I can then put on the report and leaves the original value for TYPE the same, I need it to change the original type value to a new value if the customer = XD-0060 is that possible ?

Thanks for the reply vbaInet Yes the customer field is actually a customer code eg XD-0060 which is unique to each customer it has just been named incorrectly i suppose Where do i put the code in the query ? I have tried criteria but it just brings back no data, I can create an expression but...

Hi, I am fairly new to Access and have inherited a database which I must manage in my new post I have a report (Rpt_LargeLabel)that is based on a query (Qry_LargeLabel) I have been asked to change a field (type) that prints on the report to a different name if it is for a certain customer...

Thanks for the reply GalaxiomAtHome, I think I need to go and restructure the query as you suggest, I am trying to create a Works order document via an ODBC link to two tables wdorderm and stockm on a Sage SQL server, most of the information I need is in the wdorderm table I just need to bring...

Hi, I have created new expressions each for front_lab_stock warehouse and front_lab_stock_product , then done the same for rear_lab_stock warehouse and product in a new query And then when I run the query it is fine and pulls all the correct wh/product combinations I have then created a...

Many thanks vbaInet that has worked perfectly, I have officially thanked you. Cheers Tony Banana I am not sure what you mean, I need to join on two columns from one table to two columns in the other table but creating a new query based on the other query has worked, anyway thanks for the reply...

Hi Paul, Thanks for the reply, I have tried using the full expression name but I still get the same message, it then highlights this portion of the join when I click ok Mid([film_inner_stock],1,2)=scheme_stockm.warehouse & RTrim([works_order_1]) & "-1-" &...

Hi, I am trying to get a join between two tables (stockm and wdorderm) by using an inner join on two expressions I have created in the query, but I keep getting a message stating join expression not supported. Is it possible to create joins using expreesions ? This is the sql of the query...

Hi Kryst51, I have solved this problem thanks to your help by using the DateValue function as below MfgDate: (DateValue([NEWBOX]![Date])) This gives me the date without the time and i can then add the MfgDate field to the report and add the stars in the control source using ="*" & [MfgDate] &...

Thanks will take a look where do you apply these functions is it in the field on the report not the query ? Cheers and thanks for your help

Don't know if it helps but I am using ="*" & [DATE] & "*" in the control source of the text box on the report and will then change the font to code 39 when I can get just the date to show without the time

Hi Kryst51, Yes I tried that in the control on the report and it brought the date through in the correct format, but then when I add the stars for the barcode it puts the time back in :( Thanks

Hi, I am an access newbie who has been left with a database to administer which was designed by a former employee, I am trying to add a barcode field to a report for a date field (NEWBOX.DATE) in the format dd/mm/yyyy but the field in the table also shows the time after the date, so when...