Search results

Hi I have written a select query that works well and gives the correct reults. SQL below: SELECT tblFactSalesAndStock.Line_Code, tblFactSalesAndStock.Week, tblLoadCoverBand.Cover_Band_Code FROM tblLoadCoverBand INNER JOIN tblFactSalesAndStock ON (tblLoadCoverBand.Week =...

Hi I have written a couple of Select Queries that work well. However, when I turn them into Update Queries they don't work. From reading the Help files, I think that this is because I am creating a variable in the Update Queries and also using Totalling. Both of these are necessary to obtain...

Hi I've been trying my hand at creating a few functions and all has gone well. However, one function will simply not work and I'm baffled. Below are two functions that I have created which are very similar. The first, ROS, works perfectly well in queries and returns the expected result. The...

Hi I have a fact table which contains a list of products at many different Retail Prices. I want to band these products into groups based on Retail Price Bands. I have created a second table with the fields Retail Price Band, Minimum Retail Price, Maximum Retail Price. This defines the...

Hi to All on this forum I've just joined. My name is David and I work for a retailer in a commercial role. Not part of an IT department but I enjoy learning about software and like to create databases that help make routine work tasks much quicker. I'm moderately competent at Access and am...