Search results

Hi there, I was wondering if someone could help me. I have two tables - one which contains the Invoice with details such as the Sales Rep who made the sale and the transaction date. It will also contain a total invoice cost - which is what I'm having trouble with. The other table contains...

Hi, I have a simple table where I want to insert a calculation. I have the following columns - "Quantity" and "Unit Cost" I'd like a "Total" column which gives the Quantity*Unit Cost to give the total. How do I go about doing this? http://allenbrowne.com/casu-14.html I read on the link above...

Hi everyone, I'm learning the basics of Access and I was looking for advice with regards to appending. I have a large transaction table that I am trying to break down. It had over 20 fields in it and it contains transactions with details such as customers and the products they bought. I am...

Hi there, It's been many years since I first created a database from scratch so I was looking for a quick refresher. I have one large transaction table with the following fields: Transaction Date Sales invoice number Transaction Details Product Type Customer Reference Customer Name Customer...

Hi there, I was looking for guidance with regards to this problem. Any help would be greatly appreciated :) Problem A new accommodation block has been built on a university campus close to university facilities. There are three main buildings, named Hufflepuff, Ravensclaw and Slytherin, each...

Hi there, I'm trying to get the sum of a field named "Net" and display it in on a report. i54. tinypic. com / 2nby5ux .jpg I realise that I have to put something like sum[(Net)] in the query but how and where do I put this? Any help would be excellent :) Thanks

Hi there, I have been requested to complete a query where only records which are above the "net value" entered by the user are displayed. For example, if I entered £100 into the database, it would display records of £100 and over and not records that have a "net value" of £50. Screenshot...