Search results

Good morning all. OK, so I've nearly cracked where I want to be. I have essentially had to do the core of the back-end in SQL in order to organise the data in a way that actually makes sense to ACCESS. Following this I now have a table with the following fields Stock No SK Code Free Stock Qty...

Good morning I am unsure if what I am about to ask is even feasible however it is currently the only way I can think to populate information moving forwards without having to manually update formulas each month to correct the values. In essence what I am trying to get to is displaying...

Hi, Just wondering if anyone has any suggestions on how to total up date. I have enclosed two images, 1 of the query I am running and 2 a snippet of the results. The problem I am having is that I cannot get the [Stock No] to total. Is there any way this can be done? The SQL is showing as...

Hi, I am in the process of developing a stock related database. I have imported the data as a linked table. (The bank end of the Excel table is a CSV File which comes from a further back end system). From the linked table I am running query but have been looking to add manual formulas. Having...