Search results

It looks like you're combining the customer and the car they're selling into one table. I would probably have these as separate tables. That way you can link a single customer to multiple tables. If you're wanting to track both the cars customers buy and the cars they sell, I would perhaps...

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

It's OS Codepoint, http://www.ordnancesurvey.co.uk/oswebsite/products/code-point-open/index.html

Ahh, got it! Well I don't know how, but I have worked out why. It is something to do with the fact that I have two different totals (one for balances received and one for deposits recieved, because they are calculated slightly differently). If I remove one and use the query purely to calculate...

Thanks, well it doesn't fix the original problem, but it does make the SQL make more sense for me (as I don't know much SQL and was unfamiliar with 'Having'). I also tried removing all the fields which aren't essential as well, leaving only transaction ID, status and the two sales forecasts...

Haha yeah, I know next to nothing about coding. But I did have a similar issue with UK postcodes before using data from the OS which as mentioned, sometimes has spaces and sometimes doesn't. My issue was doing the reverse of what the OP is doing, starting with a nice clean postcode, with...

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

I think what the OP wants to do is standardise a non-standardised list of postcodes, so that BL13 5NR would appear as BL13 5NR, but BL135NR would be changed to BL13 5NR without also changing BL13 5NR to BL13 5NR. (I intended to put a double space in there, but this forum is too clever by half...

Tried a few things... turns out it was the Nz() function, when I replaced it with IIf(IsNull(Field),0,Field), the thing works.

Yeah exactly, nothing has been done in Access to create this link it is purely Excel based, but there is something about the query that Excel doesn't like and won't 'see'.

No, the queries that come before the 'Nx()’ query are crosstab queries, they are the same queries that existed before but most of my reorganisation comprised using a different field for the crosstab column.

Ah, no it is a link to access from excel. The data in the query is (or was) shown in excel as a table (table being the excel formatting style, not the access object type). I'll give the suggestions here so far a try over the weekend.

I would say that unless you're a multinational corporation, databases are never as big as you worry that they'll be and accessing the data is much easier than searching paper records, it's always best to think, I might need to refer to this later (for example maybe several years down the line...

Thanks, what do you mean, connect as if it were a table? As far as I was aware, that was what I was doing.

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

I've a feeling this would be best solved by structuring your tables differently. If you are using the contracts table for the main contract and then the subcontracts table for things such as extensions, and using a many to one relationship, then you have the parent and the child tables both...

Thanks I'll try this, it seems the solution to almost every problem I have is 'this needs to be done using two seperate queries :P' was gonna say I tried using the full field address but still got the boxes. Thanks for the help everyone.

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

What is the context of this? A query can only filter records, it can't filter fields, but if you want something that will only show blank fields perhaps there is something you can do with a form that can achieve this.