Search results

I realise the post title is loaded, so i'll try to break it down. Keep in mind i only posses layman knowledge on the subject. I've created a form from a table/query which lists deliveries. Fields include, name of delivering company, product name, product shipping cost, product id. What i have...

What i have is a table with client names, purchase dates and their value. I also possess a query which shows the monthly sum total of said clients' purchases for the last year. What I need to do is create a drop down menu, in which, when a client name is selected, I could see his "monthly...

My "Date" column is a text field that looks like this: DD.MM.YYYY Since the amount of data is very large, access query returns an error saying that it cant convert a field with more than 65,000 entries. Anyhoo, I need to find a way to show summed totals for the separate months, and for the...

I have 3 fields in the query. The first is the company name, second is a for the total profit made in sales i.e. the positive(or sometimes negative) difference between expenses incurred to have the item/s in stock and how much i have sold it/them for. The third one represents the sum total of...

EDIT: since i dont have the post count to post links, you would have to replace /com with (dot)com manually if you wish to see the snaps. Sorry Hi, I need to create an access table which to hold a rather sizeable amount of data. I created this table, i45.tinypic/com/30rtg01.jpg named the...

Recently had to start working with access 2010. Im a layman on a deadline so, I need to ask for some aid. For a project i have been tasked to create relationship tables which link a pre-given list of company names to the specific items they purchase. I am given the names of said companiess...