Search results

Hi, I have a query which brings back the following columns: YEAR; PERIOD; STORE; PRODUCT; GP. The table it is referring to is called 05_FULL_TABLE and I have changed the Alias for this table within my query to 05_FULL_TABLE1. I'm trying to add a field which will rank the products by GP...

Hi I've built a macro that runs through about 12 queries one after the other, which I run every day. They basically bring in data from a data warehouse held on a Pervasive server through an ODBC link, then perform calculations based on other criteria in tables held within the access database...

Hi I'm using Forms in my DB to update data held in tables. I've successfully built simple forms that just retrieve data from one table and allow you to change the values. I now need to base the form on 2 tables (one of the tables only contributes one field to the form, which I want to use to...

Hi I think this should be straight forward, but I'm new to VBA in Access and can't figure it out:confused: Here's what I'm trying to do: I'm trying to create an order of several products from a supplier with different costs associated with each product. This bit is fine, I can work out how...

Hi I want to run queries in MS Access, then append the results to a table in a data wharehouse, which i access through an ODBC link. I can write the append query and have found the table name that I want the data to append to by browsing the network list, but when I try to run it, I get the...

Hi I keep the production version of my database on a server, and a copy of it for development work on my desktop. Today I've made several changes to the development version, which didn't work. I then opened the production version held on the server in a separate MS Access window to compare...