Search results

Hello, I have a table for invoices (one record per invoice). Each record contains a location ID and a received date. Let's call the table "tbA", the location ID "loc" and the date "rdate". Now I would like to make a query that display one line for each location and in each column shows the...

As it turns out it worked if I just swapped position of the two Select lines in the Union. No idea about why that would matter, though.

When I try multiplying Invoices by -1 (or anything else for that matter) in the first of the two Select lines (tbA) it doesn't work for some reason and I'm prompted to enter "Invoices" manually. I suppose it must be because I'm using a query (not the tables directly anymore) that sums the total...

I guess after hours of trying to figure out a solution I was not thinking straight and didn't fully understand how your query worked. Now that I do, I have to say it's a very neat solution. One that I would never have come up with for sure. ;) Thanks again

I'm now trying to use the above SQL-query as a recordsource for a subform in my form, but I would also like to throw in some sorting so the records are listed in order of backlog size (descending). I modified the second query a bit by throwing in an "Abs" around the sum(invoices) in order to get...

Thanks a lot. They worked great.

Hello everyone, I have two tables, let's call them tbA and tbB. In tbA I keep track of the number of invoices added to the system for each location on a given date and in tbB how many invoices were processed for each location on a given date. My primary keys for both tables are composite...

Thanks, but it seems that doesn't help (unless I misunderstood you). I still see multiple lines for each date listed by the query even having omitted the location number field altogether. In the list that shows up I want to see each date only once and the total sum of the count of each type of...

Hello, I have a table that looks something like this in structure: P_date (date) Location_No (integer) Invoice_type_A (integer) Invoice_type_B (integer) Invoice_type_C (integer) Invoice_type_D (integer) I want to create a query which shows the sum of the number of all four invoice types...

Thanks for your input jdraw and CJ_London. I have been given quite free reins on this project. For the moment they're using some kind of Excel sheet for this but are having problems when multiple users are using it simultaneously (probably because the file is on a remote server). Basically...

Hello everyone, I was asked by my boss at work who knows I have some experience with Microsoft Access to put together a database tool (I'm using Access 2010 which is new to me, previously I have used Access 2003) to monitor the number of processed invoices for various locations on a daily...