Search results

Thanks for all the suggestions, the filtering is too complicated to be undertaken by crosstab queries so I took the original sugestion and have a form with a combo box selection in Access, on click it opens the appropriate Excel spreadsheet in which a pivot table is stored, the data refreshes...

May I just ask, did the name on the table occurences correspond to the name in the employee table? To avoid repeated data you should have the first table with primary key EmployeeId and the second with it's own key and employeeID as a foreign key. The report can be undertaken with a query, add a...

Thanks for the answer, just tried looking into it most of the week and with no luck, so I went back to run the query for every field. But I still have a problem. The current cross tab query that I have shows invoice_net value per year for each sales agent that have a customer e.g...

I have some problem in getting to a solution for the best way to work at this. My management wants reports in table format, viewing expenditures and sales for comparrison purpose, so I am creating crosstab queries where the reports will be based on. My current line of thought is: 1. I have a...

Thanks for the replies, so I was getting to the write solution all along, just overcomplicating myself. This is my first professional database that my management asked me to create, I am still a bit in university mode. :rolleyes:

I am trying to use VBA to create a procedure that sets the background Detail section of forms in white. For ease of updating I want it to be stored in only one procedure, and for it to be called from other event procedures when the forms load. Any idea how to implement it? I can do this in...

I run this vba code to allow me to filter data in a form. The form is bound to a query with ACCOUNT_REF part of the query and txtFilterAccountRef an unbound control box. I am trying to view a specific account with input provided by a user. I am getting an error message that says: "Run time...

My mistake, the queries return the same fields, but one in relation to customers and the other in relation to products. It's two queries one that returns all customers that have and have not any invoice orders The other query returns all products that have or not been assigned to any invoice...

I'm having some problems with creating some reports, The reports are to be based on what the parameter queries returns. They would need to run the following: Customer sales report: by customer,by year, by semester, bytotal sales, by brand, etc. If you where in datasheet view you would filter...

I have two queries: Query 1- shows all customers that have and do not have any orders in the system. Query 2-All product data that have or have not been assigned to an order. They both have the same fields. But not every product is assigned to an order and not every customers places an...

I had a look at the report designer in Sage and for some reason the Join for the InvoiceItem-Stock is the other way round (with Invoice_Item having many Stock). :confused: Probably that's why I am having so many problems. Need to get back to Sage and see what they say. :mad:

this is the sql code SELECT STOCK.STOCK_CODE, INVOICE_ITEM.INVOICE_NUMBER FROM STOCK LEFT JOIN INVOICE_ITEM ON STOCK.STOCK_CODE = INVOICE_ITEM.STOCK_CODE; To get all stock items with and without invoice numbers.

That's what I tried to do I can create a select query that takes out all invoice data, but that is for the products that have orders . I needed then to create a left join select query between stock and the invoice-invoice_item query that would take out all stock items that did not have any...

I am linking 3 tables from Sage, Stock, Invoice_Item and Invoice so I had to come up with a new solution, using select queries to get the data out. 1. I linked the Stock and Invoice tables to Acess using their primary key with exception of Invoice Item. ( It had before a joint key but Sage is...

Right I'll give it a try it and get back to you, thanks :)

I tried linking it directly, but the ODBC database does not accept every query comand and it tends to crash too easely. Oh well will have to refresh the data regularly then and just link the data. Might take a few more queries than expected.:(

Yes mostly, but I found it very bad, their report designer does not allow much flexibility. It is aimed to small companies, but it does not allow much customization. So most times companies have to improvise and remove the data into another application for reporting, or resource to other tools...

Thanks for the reply, problem is when we need to create an order processing on access to be sent back into Sage, it will still be a nightmare.

I have two tables, one Stock that holds all data on stock items. Another table, SupplierProducts holds additional data on stock items. The reason why is that the first table is an appended sage table, and the second one is a table with additional data for stock items provided by the supplier...

I need to create some reports using Sage data tables. I am quite confidente producing reports and normalizing but never before worked with linked tables and as this is my first major project, I am really learning as i go along. I started by producing a database analysis and design report for my...