Recent content by jmac123

Thanks Although that method wasn't the answer, it did point me in the right direction. Yesterday I didnt have access to the full DB from home so to test the suggested syntax form plog I made a couple of test tables. I found that Access DOES accept the following syntax: Select * From TableA A...

No probs. Here is an example. TableA has forecast sales Data with following fields: TableA.CustomersID TableA.ProductsID TableA.Date TableA.ForecastUnits TableB contains contract selling prices for each Customer with fields TableB.CustomersID TableB.ProductsID TableB.UnitPrice In order to...

I am new to some of the SQL syntax required by Access I am having trouble joining a table on two field criterias eg: Select * From TableA A Left Join TableB B ON (B.CustomersID = A.CustomersID AND B.ProductsID = A.ProductsID) Access will not allow this syntax and I can only think to put the...

Hi whilst making the sample database for you I discovered the solution!! The SCPViews.Cases field had a data type of long integer which is normally ok. However, the subselect output should have cases with several decimal places and it is apparent that it was forcing 'cases' to the nearest...

To explain, The data file I am working from has Forecast units by Week. In order to get data by month I have a few calculated columns: Month A - Calculates the month number of day 1 for this particular week Month B - Calculates the month number of day 7 for this particular week...

Thanks for your reply I can confirm there are no NULLs in Year column. The returned dataset is perfect until a group by is added

I Have done a bit of database administration in other environments but am fairly new to access. I have a peculiar problem that I have been trying to solve for almost 10 hours now :banghead: Any help on this would be really appreciated. I have searched existing threads to no avail. When I run...