Search results

Access 2000

Hi All, i tried this... =IIf(IsNull([SumOfBudget Admissions]),0,([SumOfBudget Admissions])) But coming up with an error??? Any ideas? The above formulae was in the detail of the report.

Thanks will try this out.

Hey, Thanks for your reply, will try and let you know how i get on. Cheers

Hi, Also hijacking this thread. Is there any chance of an earlier version access to do this in? This would be perfect for project im working on????

Hi All, I am wondering what to do to put a default value in feilds which are blank. Would like a default value of 0. There is no default value in the properties of the bound text box in report view???

That done the trick, thanks for the advice.

Hi All, Head is battered with this join query. I have 2 tables which I want to join, one being individual data and one being budget data. I want to Sum the budget Cost And Budget admissions dependant on the joins. SELECT FyldeCoastActivity.Speciality AS [Specialty Code]...

Could you send me details of this as this could be of interest to me. Is the software frewee? Andrew

Yes, within a column called calcualtions. But there may be other data in there such as 13001 * 234 etc etc

Maybe I didn't understand. You have this query which is returning a set of MetricID's. So what else did you want to do with it? OK I created a query from a table which has over a thousand records, the query has some conditions and the query gets the records down to 13. These 13 records are...

I have tried this but, could not relate the query to the calcualtions column? Any ideas?

Hi Is there a way you could look up multiple number in a query were the column will be a series of numbers/calculations? E.g. I would want to look for 13001,13002,13003, in a column where there would be calculation such 13001 * 246 13001 * 269 13002 849 etc etc Any help would be much...

Hi I have come to a dead end with my query. Any help would be really appreciated. I have a query which i have written: SELECT TblBurnleyWwTw.MetricID FROM TblBurnleyWwTw WHERE (((TblBurnleyWwTw.[Data Source])="OMS")) OR (((TblBurnleyWwTw.TAGFunction)="CHP")) GROUP BY...

Is it possible to create a combo box to list all record ID, when selected that record appears on the form?Ifso how would i go about this? Thanks in advance? Andrew

Thanks for your reply Gemma docmd.openform formname:="myform" openargs="dataentry" Were would i put this code then? Two different forms ? how would this approach work and how would i go about doing this?

Hi Could anyone help with code to open my form in add new record mode? Thanks in advance Andrew

Gemma This is spot on!! Another addition, would it be possible to highlight that field to show the compulsary field?

What happens if another events is already in there? I have the follwoing code in there now: Private Sub Form_BeforeUpdate(Cancel As Integer) On Error GoTo BeforeUpdate_Err ' Set bound controls to system date and time. dateModified = Date TimeModified = Time() UserID =...

Hi All What event should i Use to update a subform which is based on a query to update when a new record is added? I am using me.requery but I dont know what event and what form it should go in??? Any help would be much appreciated Thanks Andrwe