|
Tuesday, 12 May 2009 09:24 |
|
Hello, i need a very simple Acces school exercise. See attached for PDF doc.
Its a form based on the following data fields and 4 querys:
• SIGN:----------text and numbers, key value
• CAT:----------check box, not mandatory, it can be filled with a X or it can be empty.
• LOC---------- check box, not mandatory, it can be filled with a X or it can be empty.
• OBSERVACIONES----- text and numbers
• CATALOGADORA—text and numbers
.NAME
.SURNAME
.CLAVE
• FECHA -----date values( day, month, year)
SEARCH QUERYS:
I need to make the following searchs to be able to know:
 How many and what sign did make catalogadora “X”, on day”X”, month”X” of year “X”
 What sign(s) were added on day “X” and who was the catalogadora who added it?
 What re the signs that has filled OBSERVACIONES field and option to can make a search on this field.
 How many and what SIGN are cat and how many and what sign are loc, and who added it and when?
|
