Search results

  1. G

    Append query (ran from VBA) adds records, despite key violation?

    Bit of an odd one... - I have a module which runs queries on linked sales spreadsheets, to merge them in to one Access table. - To prevent duplication of sales, the primary key merges the sales record and item number fields. Today, it's found 103 key duplication errors, which is fine. But it's...
  2. G

    Opened exclusively error on split database?

    I have a multi-user database. I've split it into a front-end and back-end. Distributed copies of the front end to each user. Thought I was sorted... However if I try to open, in any view, a query that somebody else is using, it comes up with the 'Opened exclusively by another user' error. Any...
  3. G

    Not part of aggregate function

    I've tried using the search but besides it not being possible the 'easy' way, I can't find anything specific to my function. I *think* it'll be some sort of subquery, but I'm only just getting used to writing SQL by hand so still need a little guidance... I need the minimum cost, grouped by...
  4. G

    SUM query (only include values if they meet a condition)

    I have many suppliers for many products. I want to get a total quantity for each product (stock from all suppliers). This bit is pretty simple! The problem is, two of the suppliers are actually the same. In the below example, it's A and B. There isn't duplication for every product, they sell...
  5. G

    1-to-1 relationship based on two fields

    A 1-to-1 relationship based on two fields. Hear me out... tbl_Products has a one-to-many relationship with tbl_Stock. Each product can have many suppliers. tbl_Stock has a one-to-one relationship with an external feed (which I have no control over), containing cost, quantity etc. There are no...
  6. G

    Relationship for multi-variable discount table?

    Hi! I'm designing a product database. 1. Feed - this is linked to a CSV so can't change anything really 2. Products 3. Products_Feed - links 1 and 2. Multiple suppliers for stock so this basically says OurCode | SupplierCode Then there are tables for Category, Manufacturer and Supplier...
  7. G

    Hi!

    Hi, I'm Graeme! I'm a web designer by trade, working for a small computer parts e-tailer. Did a bit of Access at school but just jumped in at the deep end with a project at work so looking for a bit of help! This website has come up for every 'how on earth do I do that!?!' query so seems like...
Back
Top Bottom