Search results for query: *

I'm having brain freeze on the best way to do this. I have a crosstab report listing routes as it's rows and giving a count of people on those routes as it's columns. Fairly simple yes? What i need it to do is count how many of those people were on that route per year for the last 5 years...

I have a running total that gives me a distinct count of kiddies that have been allocated preference 21 per school they have been allocated to. so the running total goes Summarise: distinct count of student.stud_id Evaluate (use a formula) {CHOICES.ALLOCATE_FLAG} = 'Y' and...

Morning, does anyone know of a way to lock the size of a text field down to characters (say 10 for example)? i know you can lock size and position but doesn't that only lock what is displayed not entered? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Whoever battles with monsters had better see that it...

On a bus this morning i saw an advert against domestic violence. the strapline was: 'That'll teach her to answer back' Now i'm curious, surely that (being some form of DV) will teach her NOT to answer back? Am i gramatically incorrect or are they? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Whoever...

I'm a bit of a newbie at excel formulas and i have a question. I have a formula that is meant to be working out if something falls on a weekday. if it does then it's meant to be putting an amount sourced from a different sheet (same workbook) into the field and if not then it's meant to be...

Why is it that so many people get these two words wrong? More to the point why do so few people use affect these days? Affect verb (used with object) 1. to act on; produce an effect or change in: Cold weather affected the crops. 2. to impress the mind or move the feelings of: The music...

I need to insert 4 values into a table and attach those values to a value in another table. can i do this using a single insert statement? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ "Whoever battles with monsters had better see that it does not turn him into a monster. And if you gaze long into an...

I opened an existing report called 'Final statments issued by officer'. when i opened it, the top of the report called it 'Contact between 2 dates'. i made some amendments to it and moved it into a new folder whilst also saving it as 'Finals Issued'. when i opened it again, you guessed it, it...

I have a formula that currently changes the colour of a date field if the date is older than 7 days: if Maximum ({DX_XML_LOG.PROCESS_DATE}, {BASES.BASE_NAME}) < currentdate - 7 then red can i change this so it puts the date in italics under the same condition...

I have a report with 2 date parameters (date from and date to) running as a 'between' option for a single field. I need the dates given in the parameter to pass through to a subreport to pull through different information for the same dates. I know i've done it before but i can't remember how...