Search results

  1. W

    Understanding the use of Domain Aggregate functions in a query

    It's quite big as I combine invoicing with accounts... I'd have to make a subset of the just the tables that affect this query.
  2. W

    Understanding the use of Domain Aggregate functions in a query

    Thanks, because I'm getting an error at the moment. My expression is: DSum("Amount","Invoice Totals","Client = " & [ClientBal]) (access automatically puts the square brackets around ClientBal) As for each invoice I want to Sum the 'amount' field in the 'invoice totals' query for invoices with...
  3. W

    Understanding the use of Domain Aggregate functions in a query

    Thanks I'll give it a try... it all makes sense when you put it that way, I remember the help saying that the expression is a string, but wasn't really treating it as such. Hopefully the performance hit shouldn't be too much of an issue, but I'll let you know. This query will only be run once...
  4. W

    Understanding the use of Domain Aggregate functions in a query

    Hi. I'm currently trying to create a query which works out from the following information what the outstanding balance for each invoice in a table. The total amount that was invoiced The client the invoice is for The total that client has ever been invoiced The total that client has ever paid...
  5. W

    Data connection to Access from Excel, Data doesn't match.

    I have a query in a database I use to manage my accounts, each record is a transaction. No calculations are carried out in this query it simply brings together calculated results from other queries to show the correct value and date of each transaction (other queries are used to ensure that the...
  6. W

    Managing a many-to-one relationship from the 'one' end.

    Not so much that, but it has been 8 posts now since my original question was addressed so I felt it was time to call it a day... I have an answer, it'll take a bit more work but I'm sure I know what I want to do now. The table structure has worked well enough for the last two years, there's...
  7. W

    Managing a many-to-one relationship from the 'one' end.

    No there are two sets of records, actual transactions and forecast transactions (which are every bit as real as the actual ones). At the moment I have them in a one-to-one relationship, effectively tagging the actual information from the bank onto the transactions I have already forecast (so...
  8. W

    Managing a many-to-one relationship from the 'one' end.

    The database is the intermediate structure. The database records are not the statements themselves, they are transactions as they are listed on a statement, it is easier to just call them statements as there is already a table called transactions. The significance of a transaction listed on a...
  9. W

    Managing a many-to-one relationship from the 'one' end.

    I have an idea of what sort of form would be ideal, if it is possible. It would be a form based on Statements (aka groupsofthings aka transactions on my bank statement), with a subform based on Transactions (aka things, aka transactions in my accounting system). So far so, good, using the...
  10. W

    Managing a many-to-one relationship from the 'one' end.

    Yeah I can do, I had avoided it, because when I try to explain what tables are on the one and many side of the relationship it becomes less clear which is which as they both represent the same thing, but from different sources. Things are transactions in my accounts Groups of Things are...
  11. W

    Copyright, When, if ever?

    Actually in the UK you don't even have to do that. If you create something you don't have to copyright it, it just is copyrighted. However I think you'll find a database or something else that is more a solution to a problem than an artistic work must be patented rather than copyrighted.
  12. W

    how can i advertise my locksmith business at low cost

    Do you offer an emergency service? Because if you do then dropping business cards door-to-door might be the best way to do it, people will put your card in their wallets if they think it's the sort of thing they might need in an emergency. Other than that, I'd say Google Adwords is the way to go.
  13. W

    Managing a many-to-one relationship from the 'one' end.

    Gemma-the-husky - it's sort of the opposite way to that. I have things and I have groups to put them in, but instead of 'I've added a thing, now what group does it belong in?' the process is 'I've added a group, now what things belong in it?'. So although being one-to-many means it's only really...
  14. W

    Managing a many-to-one relationship from the 'one' end.

    I've posted this in general as the answer could involve use of a query, or a report or it could involve changing the table structure, I don't know exactly which other forum would be most relevant. Say I have a many to one relationship, for simplicity we'll call the table on the 'many' side...
  15. W

    Field for Multiple Sales on Single Record

    The answer to this I think is our old friend, the many-to-many relationship. This time connecting customers to flights with a 3rd table, which could be called customerflights, or in this case it is often normal to call the 3rd table orders, or bookings. The bookings table will then have a field...
  16. W

    Zero not showing up in telephone numbers

    UK phone number are all 11 digits (including the preceding zero) Major cities have 4 digit area codes and 7 digit numbers, smaller towns and cities have 5 digit area codes and 6 digit numbers. Occasionally you'll come across a supposed 6 digit area code with a 5 digit number, but this isn't...
  17. W

    Suggested table structure for an accounting system

    Thanks, I did have a look at the data models but none of them addressed my exact requirement. I know that I will probably have to either do one or the other of the two things I mentioned in my original post, but wasn't sure which would be best. I can't think of a third way anyway. I think...
  18. W

    Suggested table structure for an accounting system

    to Opcode, I would create a new thread unless your question is exactly the same as mine, if there are subtle differences between what you ask and what I've asked then it becomes difficult to see what's what.
  19. W

    Multivalued Field or Sub-Table?

    You would create a many-to-many relationship, as one employee can have many certifications and one certification can be held by many employees. You create a 3rd table to link the employees and their certifications. You could call it something tblEmployeeCertifications so that you know that it...
  20. W

    Multivalued Field or Sub-Table?

    I would create a table. What you're doing when you type in the lookup values yourself is creating a domain which isn't a table (or at least not one you can view and edit in the same way as other tables). So really you're not using a new feature, just be sure to explain your knowledge of this in...
Top Bottom