Search results

Thanks, I think I'm gonna stick with doing the calculation done in excel. Fewer steps between adding a new item to be purchased and seeing how it affects my cash flow.

Just having a closer look at which values appear as null in the problem field, I've worked out, it isn't as simple as it just being negative values which aren't displayed. The calculated field which contains values to be input into my cash flow forecast, is the sum of three other fields...

Well I don't know what the code is for the export, or how I could view it, but my method is as follows: Excel 2007, xlsx file. Data > From Access > select accdb file in 'select data source' dialogue box, Select table dialogue box lists both tables and queries, select the query I want, click...

Thanks again. I tried it, both with and without formatting as xlsx both times the negative values appeared as they should do.

The negative values appear exactly as they should in the resultant table.

Thanks I'll report back momentarily

The item being exported is a query, as far as I'm aware it is just exported as a table. Well through the external data feature in excel, and then selecting the query from the list of tables and queries. Other calculated fields appear normal. It's just this one field, which is frustratingly the...

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

Thanks both of you, the 'IN' version worked perfectly, I'm still not sure what the problem was with 'OR' but I'll bear this in mind next time I want to do something like this.

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

How exactly do packhouses, farms, primary and secondary suppliers relate in the real world. Depending on this, it may be that your table structure needs rethinking. It sounds like your problem is that if a primary supplier doesn't have any secondary suppliers, you have a null in that field...

I think you need a separate table for remarks, so that each job can have multiple remarks. I would imagine you want a field for the remark itself, a primary key, a field for the date and a field linking to which job the remark is for.

Thanks a lot, that works perfectly, just when I'd braced myself to be told it cant be done.

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

The criterion you want in the renewal date field is <Now()+90 This returns days with dates less than the date 90 days after now (adding and subtracting from dates does so in days) If you don't want to show contracts where the renewal has passed then also add the criterion >Now()

Thanks a lot, I did a fair bit of tidying up as I was trying to do too much from that CA01 query anyway, but I've made sure no fields are created and used in expressions within the same query and the crosstab works fine now. This would be a good FAQ point.

Thanks, so what your saying in general is avoid using fields calculated in query X as part of further calculated fields in the same query. If you need to do multiple stages of calculation, use separate queries for each stage?

The first one is CA01 query The second is Sales Figures - successful stage

SELECT Commissions.[Agreement Form], Commissions.[Advertiser Name], Clients.[Business Name], Commissions.[Agreement Date], Commissions.[Commission ID], [Agreement Types].[Agreement Text], Commissions.[Other Agreements], Commissions.[Base Licences (Standard)], Commissions.[Additional Licences...

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