Recent content by derek-dc

hey, i have a library database, that stores keywords from each book - i was wondering if it is possible to search based on more than one keyword i.e. have the ms query parameter box prompt as many times as required (when the user enteres nothing - null - the box will stop prompting) - if that...

wouldn't you be better using a fixed length number, or alpha key? having different length usernames could cause trouble or confusion later on.

Here ya go :D

thanks Ziggy, but i dont think i explained myself well. What i need to do is calculate the sum of yes/no checkboxes on a report, but limit the records on that report by a value i.e. show all employees that worked less than 10 shifts. I need to sum the shifts, then not show the record if they...

Alright, I have a db with three tables - tbl-emp which lists employees, tbl-pay which lists pay periods (id and rough dates) and tbl-details which records roster/availability/actual shifts worked etc (these are stored as check boxes i.e. Monday Week 1 of Pay period 1 AM has its own box, PM and...

Thanks Ziggy, though i have just used the =(sum(yes/no)*-1) formula in a report footer, which seems to be working fine for the moment :P Cheers

Hello, Alright heres a problem for you's. I have a table which holds roster information for staff. For each day in a 2 week period, there are 3 checkboxes, 'am' 'pm' and 'nt'. I need to perform a count on how many are 'am' 'pm' or 'nt'. For example, if 3 staff members worked on monday week 1...