Search results

Thanks very much. how straightforward was that?! how stupid am i?!

i have a report with 'AdvSectionID' header and 'AdvSectionID' footer. in the detail section there's a field called 'NetDays' (the amount of days it takes a Section to do something). in the report footer i have 4 fields: Total cases cleared in 10 days...

i'm having sort of the same problem. My report represents particulars of a meeting; who has attended and how long it has lasted. I have 4 fields: Meeting (stored in Meeting Header) Time_Taken (stored in Time_Taken Header) Date_of_Meeting (stored in Detail) Staff (stored in Detail) The report...

Problem solved. Thanks for all your help.

Sorry about that

db attached

Thanks, but it's still not quite working... if [txtRetdBySol] is null, add 35 to [GuidDateReceived] IF [Guide Type ID] = DGMAm, and if [txtRetdBySol] HAS a value, add 35 to [txtRetdBySol]. this works fine, but what doesn't work is if [Guide Type ID] = SAOLET or DMGM, the same rule needs to be...

I tried this: =IIf(IsNull[txtRetdBySol], Dateadd("d",35,[GuidDateReceived]), IIf([Guide Type ID]="DGMAm", Dateadd("d",35,[GuidDateReceived]), IIf([Guide Type ID]="DMGM",Dateadd("d",14,[GuidDateReceived]), IIf([Guide Type ID]="SAOLET", Dateadd("d",14,[GuidDateReceived]))))) and when i try to...

I tried this, it doesn't work. Should i use 'And' anywhere in this? i originally used it, but someone told me to take it out???? =IIf(IsNull [txtRetdBySol],[GuidDateReceived]+35, IIf([Guide Type ID]="DGMAm",[GuidDateReceived]+35, IIf([Guide Type ID]="DGMAm",[txtRetdBySol]+35, IIf(IsNull...

Brian, it's not. isnull throws back an error. the spelling i've used is correct. :o

this is my problem... i havea form, with 4 fields (there are more than 4 but that's beside the point). [Guide Type ID], [GuidDateReceived], [txtRetdBySol] and [TargetDate] I am trying to populate [TargetDate] and have created the following expression, which doesn't work: =IIf([txtRetdBySol] Is...

genius! i'll try that.

My problem is that i have a query which displays a series of totals for a nominated period of time, based on date parameters entered by the user. This works fine. I also have a query that does exactly the same thing, returns a series of totals, but without the date parameters. What i am trying...

I have tried this and it doesn't work completely, you see the 'status' field can be set to 'PC' , 'AS', 'SD' or 'WD', and i only want the input mask on the field when the user tries to enter 'PC' and the value in 'balance' is zero. the user can enter 'AS', 'SD' or 'WD' in to this field... can...

To remedy this problem, i had to put the details into a report, which gave me the desired results. The crosstab query doesn't seem to be able to deal with this one. thanks anyway.

Thanks for that. I'll give it a go.

I get 3 rows, and 3 columns. C1, R1 = 'Grand total'(heading) C1, R2 = Total 'Town 1' (value) C1, R3 = Total 'Town 2' (value) C2, R1 = 'Town 1' (heading) C2, R2 = total 'Town 1' (value) C2, R2 = BLANK C3, R1 = 'Town 2' (heading) C3, R2 = BLANK C3, R2 = total 'Town 2' (value)

I'm sure this seems very simple to some, however i am finding it difficult to obtain the results that i want. I am trying to create a crosstab query to display the following... 2 columns, C1 and C2. 4 rows, R1, R2, R3, and R4. Values displayed in these fields are derived from 2 queries...

I have created form on which users enter payment details, and i want to put some kind of input mask on the form to prevent the following... for instance: i would like the user not to be able to change the value of the field 'status' to PC (Project complete) whilst the 'balance' field on an...

I managed to get this problem sorted out. Thanks anyway.