Recent content by Ashleigh

I have a similar problem.... did you get it sorted? I cant find any other info?

Good evening, I am a (fairly) novice Access user. I am customising the Access Northwind Template to my own needs ( as you do). I am very close to getting it right but I want to force it to create a Purchase Order for each Item purchased. I dont need the Inventory In/Out/Ordered as I buy from...

Good afternoon, all, as an Access Novice I apologise if I dont word this question correctly, however I am having a problem combining parts of an address into one field on a Report. In a table I have the following fields: Company Name; Address1, Address2, Town, Post Code. When I 'concatenate...

Hoorah, thank you very much - worked like a dream.

Thank you for looking at my problem. I have used the Northwind template and have these tables, Orders, Order Details, Products, Suppliers, Venue Details amongst others. Order details table incl Field "start time" of an activity'. Venue Table inc the field "Journey Time". An Itinerary Report...

I should add that the start time field is in the 'Order Details' Table and the Journey Time field is in the 'Venue' table.

Thank you for replying quickly. The reason for the calculation is that I am doing an Order Database for Accommodation and Activities, from which I can produce an Itinerary. I will know the start time of an activity and the journey time to get to the Venue, so I need to be able to advise when...

Morning all, I am fairly new to Access and am currently trying to subtract minutes. I have two tables One contains the Field "Activity Start Time", another contains the field "Journey Time". in a query I want to calculate the departure time, i.e. Start Time minus Journey Time. how can I do this...