Search results for query: *

I really need help with this one. I have a csv file that i import via excel. Everything works fine,except in my memo field I have square boxes which I can strip out easily enough by removing Chr$'s 10 and 13. The problem is I actually need the carriage return so it prints correctly in the...

I forgot to add the code I was trying to use vartemp=dlookup("[socialsecurity]","test results","[socialsecurity]=forms![test results]![socialsecurity]") vartemp=dlookup("[test]","test results","[test]=forms![test results]![test]") if...

I have a form with a combo box (socialsecurity) that links to my subform "test results". So I pick a person from the combo box and my subform show all the tests they have taken. It looks like this SS# Test Name Score Retest(this is a check box) What I want to do is when I go...

That Worked! Thank you all for your help! Thanks Cosmo.

..also this is a summary report and my query is grouped by classes and gender and sumed by my check box fields, if this helps

thanks, no this isn't ranebow, i read that post and when i tried it i got an error, im not sure if this is because i'm using a value list for gender in the original table or do i need to put the ID field in my query and reference the query not the table..any help again would be appreciated, thanks

I have a report based on a query that groups first by class and then by gender. My report counts my check boxes just fine. But I also need it to count by gender. Gender is text and is a value list in my original table. My question is how can I count gender while also grouping by it? Any...