Search results

Hi, Can somebody tell me the expression which I need to use if I want to display the result of a Query in my form. I know its =Dlookup but its not working

Hi, I have been trying to get help in the Form forum and I am having problems attaching my database. How do I Win Zip my database so I can attach it. Sorry if this is a stupid question Lisa

Hi, I wonder if somebody can help me. I am trying to create a sub form within my form for staff sickness records. I have a table called "Sickness" for which I have each individual member of staff and their sickness dates From and Until. However, when I create the subform it shows every persons...

Hi, Can someone tell me how I can get the result of a query into an unbound text field on my form. For example, I am creating a staff database which records Sickness and I have a Query which contains dates From and To. Ive managed to create a calculation which tells me the total number of days...

How can I get a result from a Query to display in a form? For example.....I have a database which records staff sickness and I have created a Query which does the following Days: Sum([Sick Until]-[Sick From]) This calculates the total number of days any one person has taken off due to...

Hi, Can somebody PLEASE help me. I am trying to create a staff database whch records Annual leave and Sickness details. So far I have created a table for "personal details", "Leave", "Sickness" and "Training". I then created a form and used subforms to insert the Annual Leave and Sickness...