Search results for query: *

and the prize for the worlds biggest idiot goes out to me!! your right, it was an alignment problem. extending the column did indeed display the full address. Couldnt see the wood for the trees! thank you very much!

Yes, ive had a look at the rogue records and it appears to be happening where the length of the address exceeds 20 characters. 40 King George Square for example becomes Square.Transferspreadsheet seems to work fine. I was just hoping to use SendObject so that i could automatically generate...

Hi Remou, I get the same results if i send the table rather than the query?! Im not really sure on the updates to be honest. My machine is quite locked down by our IT department. It would be them who would take care of any updates. Im not sure how often this is done, if at all!!

Hi Remou, No the field is a text field with a length of 32. Thanks

Hi, Ive set up a macro to email a query out in excel format. Ive used the SendObject command. When the email is recieved certain information in a particular field is missing. The field in question holds address information. On some rows the address seems to be trimmed. For example, it may...

Hi Dagon, Thought that might be the case! nothings ever straight forward!! do you know of any good tutorials / online resources on this particular area? Its something that i'll probably need to use over and over again so worth the time investigating. Thought it would be quite a common thing for...

I have produced a cross tab style query using the following SQL; SELECT uio.owning_organisation, COUNT(DECODE(pu.progress_code,'AA',pu.person_code,NULL)) AA, COUNT(DECODE(pu.progress_code,'AACK',pu.person_code,NULL)) AACK, COUNT(DECODE(pu.progress_code,'SCH',pu.person_code,NULL)) SCH...

I actually needed both! we operate two systems here. one group of people will require the query in oracle. The rest will use access! strange i know!

Hi PHV, Thanks for your help. Ive managed to create what i need based on your queries. Got to go and translate into oracle sql as well now!! Thanks!

Hi Dagon, Thanks for your help. Ive managed to accomplish what i was after by investigating the use of RANK(). I produced a query that ranked each row using the following; RANK() OVER (PARTITION BY person_id,app_num,stage ORDER BY sequence DESC) As Rnk. I then placed criteria on the report to...

Hi Cmmrfrds, It is indeed an Oracle SQL question. As it happens i have to produce a similar thing in access as well. The majority of people that need the info use a system that requires queries to be written as pass through queries, hence the oracle question. The others use access where the sql...

Hi Dagon, Thanks for your help, thats nearly what im after! Its slightly different in that i dont especially want the max of stage_date. If the date has been edited retrospectively then the date i want may be earlier. What i need to display is the stage_date that goes with the highest sequence...

Hi I have a database table that logs the progress of a persons application form from receiving the form in the office through to attending an interview. What I would like to do is produce a query that will show me the dates when each stage was reached and the number of days between the stages...

Hi PHV, I havent got very far at all, what i came up with is the following. which doesnt quite give me what i want; SELECT progress_records.person_id, IIF([STAGE]="AA",[DATE]) As AA, IIF([STAGE]="AACK",[DATE]) AS AACK, IIF([STAGE]="INT",[DATE]) AS INT FROM PROGRESS_RECORDS GROUP BY person_id...

Hi I have a database table that logs the progress of a persons application form from receiving the form in the office through to attending an interview. What I would like to do is produce a query that will show me the dates when each stage was reached and the number of days between the stages...

Hi Pwise, Thanks for your help! thats exactly what i wanted! for future reference could you perhaps explain the use of & and + ? Ive not used + before. Thanks!

Hi, I want to create a formula or function that will display an address in one line seperated by commas. for example, High Street,anytown,anywhere The problem i get is that there are often blanks, which look odd. For example i get; High Street,,anywhere What is the easiest way of joining...

Hi, Ive got a report that contains a subreport in the details section of the report. I would like to display this subreport in all cases unless the field offer_code has a value of '33'. If offer_code has a value of '33' i would like to display a field called comments instead. Whats the best way...

Im wanting to produce something in Access that will randomly select a number of records from a table. I would like for example to input into a form the number of records I would like to select randomly.. say 20. Then get a list of 20 random records from a particular table. Im really not sure...

Hi SantaMufasa, Thanks for your response.. I'll try and explain better what i mean! I suppose the register date being different to the start date is the main reason why the report is required. It will be used to identify anomolies. We have a number of course dates that are way before the first...