Recent content by Db396

Good point - thank you. I love Access but am going through a steep learning curve. Thanks for all your comments David

You're right - pressed Run now - and it runs perfectly. Thank you. But how do you check if an update query is safe to run before running it? Why on earth would it not show the correct results in Datasheet View? Thanks David

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...

Many thanks for the really helpful advice. All is working now. I'm kind of getting into this so will read up on the basics of coding. Thanks David

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...

Works perfectly. Many thanks for your help David

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...