Search results

Thank you David. My issue was that I had not created a field that showed item price. I have now created a table to hold that data and the query now works. Thank you for taking the time to respond.

Thank you for your response. I have tried and cannot get a result. That was why I posted the question. Thanks

I have an inventory database and I would like to run a query that shows the value of stock I hold. I have not added the cost per item in the database. This is what I have: Item Current Stock level I now want to add: Cost of Item Total Value of Stock (Current Stock * Cost) Because I don't...

Thank you so much. This helps a lot. Understanding the relationships is the key for me. Thanks again:)

I am not that far advanced and am trying to build slowly. There is so much going on when you go into relationships, I am not sure where to start. I was looking for a simplified orders db if that is possible. Thanks

Thank you for the response. Unfortunately it is saying that it cannot link to linked tables in Northwind. I have Northwind open. I am using Access 2007, not sure if that may be the problem. Thanks again

I would like to build a very simple customer orders database. I have looked for examples of this and can't find one. If anyone can point me in the direction of a sample, it would be greatly appreciated. I think I need 4 tables: Customers Products OrderDetails Payment I am not sure which...

Hi Ken, Thanks for your response. This doesn't seem to work. Looking at the properties on the Northwind Form, it seems they use a split form. Would this be the option to use?

I have a datasheet that I want to include on a form. I would like the form to look like the datasheet and not just single entries. I have attached a sample from Northwind to explain how I would like the form to look. If anyone can offer any help I would be greatly appreciative. Thank you

Thanks all for your responses. No need to answer the above question, I have managed to figure something out myself!!! :D

Thanks for this Bob. This does not return a currency value. What do I need to change?

Thank you very much. This worked. Sorry for posting such a simple question.

I know there is probably a very simple solution, but I do require some help from the experts please. I want to add the 2 amounts in columns feesdue and feesoutstanding to give a total in "total". All help is greatly appreciated. I have attached a screenshot to show what I mean. Thanks

Just to save paper. If I can fit more on that would be fine

I have a DB with 150 customers. I would like to print a report each month that acts as their invoice. I am looking to get 2 customers details per page in the following format: CustID: 15 Month: Apr 10 Name Surname: John Smith AmountDue: £7.50 AmountOutstanding: £5.00 Total: £12.50...

Thank you. I have added Nz() to my new book of Access notes. Thanks for the assistance

Rich, Thank you so much. Regards

Thank you for the response. I forgot to mention, I am very new with Aceess and I don't fully understand what you mean with your reply (sorry). If you could help me in more simple terms, I would be very grateful. Thanks

I have 3 columns in my Report: AmountDue AmountOutstanding Total I have put in a Sum for the first 2 columns but it won't let me do the same for the Total column. I want to either have a total of the total column or add the totals of AmountDue + AmountOutstanding. Thank you in advance. I...

This doesn't seem to work. I am not sure where I am supposed to type this in design view. Thanks