Search results

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

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

I have two tables at the heart of an accounting system I built in Access. [Transactions] is a list of transactions used (via an export to excel and a pivot table) to create cash-flow reports and forecasts, [Statements] is a list of actual transactions downloaded from my online banking. They are...

Hi, I hope for a little advice on an issue I'm having with an query, where the results of aggregate functions are clearly incorrect. I have a query which is supposed to take transactions (records which are used to create a pivot table which shows my cash-flow) with the status 'Sales Forecast'...

Hi all. I have a query which I have connected to an excel worksheet. The query displays as a table in excel. I've been using it for a while without any problems. Recently I've decided to reorganise the data that goes into the query, however the query itself hasn't changed, there's a chain of...

This is my first foray into Macros, using Office 2010. I have a form which contains a single combo box to select from a list of invoices which invoice I want to open, this is based on the Invoices table of my database. Then a button which I created using the wizard to launch the Invoice report...

I have a query based on tableA in which fieldX and fieldY are the sums of two fields in tableB, which is on the many side of a 1-many relationship with tableA. Initially fieldX and fieldY work correctly, however when I add a new column with the expression fieldM: [fieldX] - [fieldY], and open...

Hi all, I'm exporting some data to excel as a table containing external data, linked to the original, which is a query. One of the fields, which is a calculated field comes out in excel as blank unless the value stored in it is zero or positive and I can't work out why. I've tried creating a...

Can someone please let me know if I'm typing this expression all wrong, or if it's even possible to do what I'm trying to do? Any help would be greatly appreciated. IIf([Transactions]![Status]='Forecast' OR 'Reconciled' , [Updated Date] , [Original Date]) The objective is that for...

I have created a crosstab which feeds into other queries as it has been designed so that the row headings match the key of another table and the columns can be used as fields in another query. The problem I have is, in order to use it most easily I need the same three columns to show, even when...

All the following queries are based on a table which contains commissions for my business. The first one adds together fields containing charges, expenses, etc to create calculated fields containing the total commission fee and the deposit due. The second one is a crosstab query (though the...

I have a database where I store all the information about my clients, commissions, invoices, etc and I intend to use it to produce documents such as contracts, invoices etc from the data I have entered. Right now I've a couple of invoices to produce and as I see it I have two options, create a...

To quickly sum up what I am trying to do, I have Query 1 and Query 2. Query 1 has fields A and B, which correspond with Query 2 fields X and Y. Query 1 also has field C which contains the values I want to access. What I want is to create a field Z in Query 2, which displays the value C where...

I have a specific requirement of a query I'm creating, which is difficult to describe in the title of the thread, but what I was is to create a field in a query which takes a value from the record, but then subtracts the values of all the other records with the same type ('type' being a field)...

Hi all. I want to create a query based on a table 'X' which is on the 'one' side of a one-to-many relationship with table 'Y'. The purpose of the query is to provide the recordset to a form to edit the records in table X but I want to include totals from the linked records in table Y for...

Hi. my problem is that I want to create a query and then have a table which effectively always shows the results of the query. The reason for this is I want to access the results from another application, and this application can only read tables, not queries. I tried a combination of an update...

I have a split form, I have included a screencap below: As you can possibly see, this is showing data on commissions (I'm a professional photographer) and this is a record created to test the database. Commissions is one table and most of the data visible in the screencap is from that table...

Hi everyone, I'm new here and registered because I have this specific issue and could do with some advice. How can I get the category axis of a pivot-chart to display 'properly' when the field I have placed in it accepts multiple values from a list. I can illustrate my problem with a...