Recent content by wmphoto

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.

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

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

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

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

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

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

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

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

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

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.

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.

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

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

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