Search results for query: *

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

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

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

Help! Im stuck trying to produce a query which needs to use sub queries. This is an area where I always seem to struggle! Basically, im trying to produce a query that will display for a learner, the course code, the course start date, and register information related to that course. The...

Ive produced a two column report to display employee photos alongside some basic details. How can i make the title of the report span the full width of the page rather than just the width of a column? If i make it bigger the column size increases and the report goes onto two pages.

I have a query that contains the following fields parent_event_number, linked_event_number, week_pattern, event_start, event_end, Effective, eff_wk Each parent_event_number may have more than one linked_event_number. What I would like to do is group my query on parent_event_number, then display...

Im trying to produce a query that will give me Monday’s date for the current week. I can easily work out the next Monday’s date using Next_Day(sysdate,’Monday’) , I could then subtract 7 to get the required date. This however seems a bit long winded! Is there an easier way to calculate this?

I have an access query which I need to convert to Oracle SQL. The access query contains the following 2 expressions, Funding: IIf([SPCL_FE_HE_FUNDED] Is Null, [FE_HE_FUNDED], [SPCL_FE_HE_FUNDED]) Hours: IIf([FUNDING] In (“40”,”41”,”42”),0,[FES_POSSIBLE_HOURS]) Ive translated the first into...

I have a basic query which lists the courses that each team member is currently attending. There is more than one row per person as many are attending more than one course. What I would really like to do is display each person once, and only display the course details for the course that takes...

I have created a macro to produce a pipe delimited text file. The macro first runs a make table query. The query contains the following field, Expr1: "forename" & "|" & "surname" & "|" & "dateofbirth" & "|" & "postcode" & "|" & "address1" & "|" & "address2" & "|" & "address3" & "|" &...

Ive have 3 individual reports that I would like to combine onto a single report. The 3 reports are unlinked and all have report headers/footers, page headers/footers etc.. that are different. Ive tried creating a single report and inserted the 3 reports as subreports. When I do this the page...

Ive have a table that holds information about applications to courses. The table holds the year of the application and the date of the application in the following format; Year Date 0607 21/05/2006 0708 28/07/2007 0607 04/03/2006 What I would like to do is produce a query so that I can...

I have a text field that holds attendance data for a person in a given year. The Field will always be 52 characters long. One for each week in the year. What I would like to do is search from the right hand side of the string and return the first “/” which is the code for present. In theory this...

I have a table that contains information for a number of departments. What I would like to do is split this table down by department so that I can produce a seperate table for each department. These will then be used to send out to departments to allow them to check the information contained...

I am trying to write a query that will total up the number of people on a particular course over and above a set age. For the example, the total number of students aged 19 and over. This is the query I have so far.. Select Sum(Case When date_of_birth Is Null Then 0 Else...

I have two queries that i would like to output to excel. Query1 and Query2. So far ive created a macro which will output the results of each query to excel and prompt the user to select a location for the file and give it a name. This works fine, however, im getting a seperate excel document for...