Search results

OK, I might go with the report then. I don't need to enter/edit data as I already have a form for this. For now, with just two invoices the it won't matter so much that I have to select the page number I want to print out for each invoice, as I get more I can work with your technique to easily...

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

Thanks, the SQL code was something like: SELECT C FROM 1 WHERE A=X AND B=Y I tried going into the queries and creating a single field which combines the data for both A&B/X&Y... I was able to do this for X&Y but not for A&B... I got a 'type mismatch error'. I don't know if it has something to...

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

I tried this already, I did have to remove the transactions table from the query too, but then I could edit it. Bob_fitz's advice of generating the totals in-form rather than in-query works perfectly though... well almost perfectly, one slight niggle that I can live with if it can't be fixed...

Thanks, I've tried that, but I get the error message 'You tried to execute a query that does not include the specified expression 'Item ID' as part of an aggregate function' That is with a field with this expression: Total Transactions: Sum([Calculated Transactions]![Cashflow Input])...

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

What Gina says sounds about right... if you go to the query design and double-click the line connecting the two tables there will be three options at the bottom, to return all records from employment history, to return all records from engagement or to only return records where both match. I'm...

I took the " symbol off the statement you suggested and it seems to work now. I can't say for certain yet, the query returns no records, which is what I would expect as I haven't created any new records since creating the destination table. The proof will be when I do add a new one.

Does this work with Access 2007? I'm getting a syntax error and realised I hadn't mentioned I was using this version.

thanks a lot, yeah I have a primary key which I can use for these. giving it a try now.

thanks a lot, I was hoping that somehow there was a way for the append query to do this.

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

Sorry, I figured out why 'TEST' appeared three times. While trying to find a way of combining a list of appointments and detailed expenses for the selected appointment on one form I added some fields from appointments to the form and ended up with a form based on a query based on appointments...

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