Search results

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

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

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