Recent content by SpikeyA

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

Perfect thank you!

I've attached what I've written and the Error report, not sure if this helps at all.

Thanks CJ, however I think what you've stated is my problem, one of my fields is set to min from a linked table. Is there anyway to Edit the Linked Table or append the field names of the data imported? The following comes up at the moment when I click datasheet view: Syntax Error (Comma) in...

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