Search results

a report with several field Element Value Min Max The data comes from a table where there is always a 0 in the fields min / max I would like to put some kind of expression in the field min and max on the report that if the field value is Null (or empty) it will show the value from the field...

I have a table with about 20.000 records. From this table I would like to "search" in a column the field that holds the text with the most characters. Is there a way to find this with a formula or expression?

Sorry, I am not that advanced that I understand completely what you mean. The difficulty I also have is that the data comes from our central ERP system and I am just linking via ODBC. How could I really empty these fields?

For me it is just for display purposes. So how would you suggest storing them in a string when the fields are: Customer Name Address1 Address2 Address3 City Postal Code Country Would love to fix this problem. In the meantime I continued to find out why I still had the empty line and found...

Where do I put this code? I have created a text field in my report with the code as an expression and still I get the empty line. I also entered the code in a new field in the query which is the base for my and this has also no effect. I am using Access 2007 does this matter? What am I doing...

Hi I am using Access 2007 and have created several custom categories in the navigation pane, one for each report I have a maketable query that saves the results into a table which is saved under "unassigned objects" Is there a way to save this table directly into the correct catergory?? I...

Sorry for the vague title. I have a problem which I will post in the forms section but it also relates to table set up and queries (i think). I have added some screen shots to explain what I mean. I have a small database that hold employee info. I have an employee that works on a department...

I see what you mean. The only thing I am afraid of that the HR employees will forget to assign one of the warehouse of accounting task to a person and as I would like to get some kind of reporting per department which shows the tasks and the score for each individual on that department I would...

Doc Man, I have followed your advised and set up above mentioned tables (see attached) The only thing that strikes me as odd is that you would expect that if I have set up certain standard tasks for a department and if the department is set up in the employee table, that when I click the + in...

OK, let me add some info to make it a bit clearer. 1.) A employee is assigned to a single department 2.) Each dept has standard tasks that, ideally, and employee should all learn to do 3.) For each employee we want to keep track of how multi-functional they are I have added a spreadsheet that...

Hi, I would like to create a small HR database that holds: * Employee details (Name, Date of birth, Entry Date, Exit Date, Function,Department, Shift) * Departments * Departments and capabilities needed * Employee, departments and capability achieved (1=yes, 0=no) The idea would be to have...

Jon, This does the trick. Thanks !!

Sorry I was probably not clear. Let me use an example to further explain: Name: John Entry Date: 1-1-1994 Exit Date: Name: Jack Entry Date: 1-8-2007 Exit Date: Name: Jill Entry Date: 1-1-2007 Exit Date: 15-7-2007 What I would like to see is that when I ask for the employees...

I would like to make a query which is based on a table that holds information on employees (past and current) I take the fields: Name Entry Date Exit Date and now would like to write a query where I can select a start and end date and the outcome should then be the "active" employees during...

I have a table with open order items: Order No - Order Item - Product - QTY - Stock Reservations - Incoming Reservation I would like to create a query which shows me all order items that haven't got a stock reservations nor an incoming reservation Can someone help me with this one

I have added added the count [order no] but this doesnt'count the order no but the number of items for each order. I have grouped on Order No and then added a footer where I added the text box (see my attachment)

I have made for our shipping department a report that shows the number of pending orders (+items) ready for shipment. I have based my report on a query that shows: order no , order item, status, pcs ordered, pcs balance Via the report wizard I have grouped on the order no, and then sorted in...

I just had to turn the days and months around (european date) and it works. THANKS !!

I have a query in which I have a long list of orders and their entry date and due dates. I would like to calculate the number of working days between the both in order to see if the supplier keeps his theoretical delivery term. Can some one give me a way to achieve this in my query: DUE...

I would like to make a join between two field in 2 different tables: 1.) Table with number field for Purchase Order number 2.) Table with text field for customers PO ref (where normally above PO number is entered) When I link the both I get an error/warning message that the "types in the...