Search results

great, thanks.

Can this be done? I want to say that if a field equals one of 4 criteria, so If(or(x=1,x=2,x=3,x=4), THEN perform a certain calculation ELSE perform another calculation. I've got the formula in Excel... If(or(x=1,x=2,x=3,x=4),y+z,a+b) ...but I'm not sure how to get this to work in Access...

Hi all I have a report which produces results depending on what you select from a drop down list menu (a pop-up form appears for you to choose). When you've made the selection and then run the report if you choose another option from the drop down menu the report does not refresh, you have to...

Thanks v much!

Hi all Hopefully this is a really easy query... I have a form that I want to appear as a small size when I open it rather than maximise and fill the screen... I've tried changing a couple of settings but can't seem to get it sorted... Can someone advise please? Thanks for your help Luke

Thats great! Thanks v much for your help guys Luke

OK - Thanks guys. Luke

Hi I need to secure my databse so that other users can only access certain forms and view the reports (i.e. not be able to change any data, queries, formats etc - just view output). Unfortunately I don't have the User Level Security Wizard function! Does anyone know of another way of doing...

Hi Not sure if this is an easy one or a tricky one!... Does anyone know how to create a drop down list in a report? The report runs from a query and we would like to view the report and select criteria from a drop down list rather than use a parameter query (where users could type in an...