Search results

Ah good thinking. Thanks!

I have a report with a lot of fields, which is based on a query. The query runs fine but when I try and run the report I get an error: "Data type mismatch in criteria expression" Any idea how I can narrow this down to a certain field? I can't see anything obvious and I have a very similar...

OK, thank you. I'll give it a go but I think it might be a bit beyond me...! Especially as I just thought it would be nice, don't think its a vital function! Thank you anyway!

Sorry, what now?! My head's not managing to get round that!!

by the way - I have had to edit it a bit as the code was on the form prior to this one... does that change things? Also the form has 3 subforms...

OK, thank you. When you say Me.subformconrolname is the subformcontrolname just the name of the form you are using as a subform? Im getting an error there now (method or data member not found)

Oh great! Thank you. Just tried to put it in and with the error bit it said it couldn't find the if relating to the else... but if I remove that I get another error saying: "Compile Error - Invalid of unqualified reference" and it highlights the .MasterLinkFields line.

Hi, I don't know if this is even possible, but I was wondering if you could help? I have a form which contains 3 subforms, all linked to the main form on a 'firstname' field. This works fine, but in the firstname selection page (A form which leads to this one) I have an "All" option. When I...

ahHA!!! Dave, you were spot on... I added a iff statement around my division and it works fine. VbaINet - I think that might have been in the SQL code you gave me, looking at - think I missed that when I was making the changes! Thanks everyone!

Oh, sorry, I didn't realise you had made changes to the SQL... incorporated those now... Still not working though :-( Still falling over on current. Thanks Dave - I'll double check that as I do have some dividing.

Right... the 1st one I come accross that does it is 'Current'. I cast that to Double, and then tried to filter it... it looked like it did the filter, then the error came up.

Good point - Thanks for that, makes the whole thing a lot quicker. Still getting the overflow error though. I changed it to a string because thats what the field is being set as (XXXX) Surely you can't set that as a type of number?

by the way - I tried casting to a string but that didn't change the outcome.

Thanks for the suggestions - I'll crack on with the trail & error I guess! The SQL is: SELECT QryRatesCheck1.Phase, QryRatesCheck1.StaffNumber, QryRatesCheck1.StaffName, QryRatesCheck1.StaffAgency, IIf([StaffAgency]="Staff",([StaffInvoiceRate]),[AgencyInvoiceRate]) AS RateA...

Hum... Surely if it can deal with the whole query, it can deal with a is not null filter?? I wouldn't say it was hugely complex - I have definitley got queries that are more complex that work fine! I have tried adding the filter to other fields, as you suggested, and with some it works, some...

Hi! I keep getting an 'Overflow' error. I've had a look in other peoples questions, but all I seem to find is that the field type might not be big enough... which doesn't seem to make sense for me...: I have a query which runs fine - its a little slow but there is a lot of data and its not...

Oh right, Thanks for that - I will have a play and no doubt have more questions later!

Thanks for that. Thats sort of what I want to do... Thats the result I want, but the data is currently all in 1 table and I don't really want to have to split it all into seperate tables. Also as time goes on there are going to be more and more months to report on... and I don't want to have to...

Hey! Really don't know if this is even possible, but hopefully someone out there will have a good idea that I wouldn't think of!! OK, I have a table which has total hours against a group of about 10 names for each month. I need a report which has the names and corresponding hours going...

I'm fairly sure it would never be null... will have another think through the scenario though. And thanks for the different way of writing it.