Search results

Hi there. I've tried to post the db, but it crashes everytime I've tried, despite resizing etc.. I've been fiddling around a lot and I think I've figured out whats wrong... Fields are in boldand criteria are in italics. I have two fields (of about 18) "Competency" and Legal decision maker"...

Hi! No, I don't have any lookup fields. I have an 'autotext' one which is my primary key and then just text and number fields. The number ones either intergers or decimals. Thanks for all the help! I've kind of been thrown in the deep end here! thought I was figuring it out well but can't...

Yeah, it is a number field. I've used drop down lists with specified numerical values in the field in the input form I made. I can't understand it. Especially now that some of my text criteria aren't working. would it help to post a copy of what I've done up here do you think?

hi I'm not including quotes in the in the numerical criteria. but when I wrote the text criteria, it automatically put quotes if I left them out. Although now I see that its only filtering some of my text criteria successfully and not others! and yet they're all entered in the same way...

Hi all. I am trying to effectively filter patients off a hospital data base depending on whether on not they meet various illness criteria. I have successfully entered the criteria for text entries into my access table, for example, however, I cannot get the query to filter for numbers. I am...