Search results

Yeah my column heading is set to Month.Month which is set up to be a table with numbers just going 1-12 only when it hits 2005 it cuts it down to 10 even with a join property telling it to display all numbers from 1-12 regardless of what is in the sales history file

so to change that into my code it would be PARAMETERS [Year] Short, [Stock Code] Text ( 255 ); TRANSFORM Sum([Sales History].VALUE_AT_BUYING_PRICE) AS SumOfVALUE_AT_BUYING_PRICE SELECT [Sales History].ITEM_NUMBER FROM [Month] LEFT JOIN [Sales History] ON Month.Month = (Nz(Sum([Sales...

I already have an nz in each of the report fields (for each month) it is like this =IIf(nz([10],0)=0,0,[10]) with the 10 being the month number, so this would be for october, is this using it correctly? I think I got this bit of code from another post on this forum somewhere, although chances...

*watches the plane fly over his head* Sorry, I erm, dont really get it, Would this give me the same output as a crosstab?

What i was wondering though is is there any code so that if there is no value for the field, ie the query still only outputs up to month 10, so there being no 11 or 12 that it would just display a blank field instead of crashing the report, or if push comes to shove can anyone give me any advice...

Still throwing up the same error :( Even with another month table connecting to the query with a join connecting the two of them saying to join using all of month, and only the ones in sales history that match its still throwing the error up :( I'll put my sql code down just incase PARAMETERS...

Ah yes I am indeed, erm, how do I left join it? its just querying the data from a single table Hmm, ok I made a left join on it anyway, by hooking in the main item table and querying using the item number, but it still throws up the same error, because the report is asking for dates for the 11th...

Hi, I should point out this is my first time creating a report I have a report that runs a query that gets data based on the entered year, it works, until you check 2005 Once you do however the report throws up an error because it cant find any data for months 11 and 12 for 2005 and says...

Ah great I'll give that a whirl, thanks :)

erm, hmm maybe its just me, but thats doesnt seem to do anything at all, it says it imports data but it doesnt give me any option of what it imports or anything, hmm it just occured to me as well that we might be talking at crossways, my data is originally stored in access, and queried into...

Erm, never mind, I deleted a field and it all seems to be working fine now!!

hmm its kinda hard as for some reason it keeps deleting my spaces so I cant show you what it should be like but in sql it looks like this I want it to display the items along the top and down the side singularly with the price totalled, but it will only group them if the price is the same, so...

Ah, here-in my problem lies sadly, I have been programming for about 5 years now, but only in the last few months have i started using excel and access, and as such am still kinda learning as I go, how would i link the table to an access query? I thought the only way you could get them to talk...

I am running a vba macro in excel reading through the list of data (3000) large and checking dates, if the current dat is the same as the previous date it needs to store the corresponding value, and so on until the date changes, then average the stored values and output it on the first one, and...

Hi, I have a crosstab query I have set up, calculating the cost of a product per month it should look like 1 2 3 4 gek22 £55 £66 £77 £88 er44 £99 $100...

Yeah our server was being abit slow and timed out, so I re-did it and it turned into a double post, so I deleted the other ones, hmm thanks, I'll give that a go

I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table) and it will need to enter in the sage login information :( Does anyone know...

Ok, this might need to be in the macro section or something, but just incase, I have a query that I want to run at about 10pm every night (when everyone has gone home) , to make it even more complicated it queries from sage and creates a table each night (that i want to overwrite the old table)...

Thanks that worked a treat :) Yeah the problem with the menu was that the unique Identifier for each record was a number, but I wanted them to choose it via the company name, and that worked perfectly thanks :)

Hi, I have a drop down menu that is linked to a query it goes *table1* *Table 2(linked via area)* Company no+Company name+Area+Zone+Roundtrip distance Now the field that it stores is the company number (we deliver to the same company in differant area, so I...