Search results

I am in need of advise from you experts :-) I want to build a database stored on a server which can be used by our employees as basis for their Excel pivot reporting The idea is as follows: I make a query that will get selected data (via odbc) from several Progress database tables of our ERP...

Hi all, I am using the a transport delivery performance query and module giving me the working / business days This module I got of microsoft.com and included the holidays I would like to extend below script to use only then holiday when it is linked to the country where the goods are send...

Hello, As a newbie I need help with the following I am trying to use MS access to collect Sales data via an ODBC connection and to output it in a certain fomat. Basically I have done the following: 1. Create a maketable query to extract ALL sales data from 2008 into a table called Sales2009...

I am trying to clean up and organize a database through a series of queries. First I have a maketable query that creates a local table Then I have some update queries that clean up the local table and put parts of a long line of text in a column over various columns Finally I have a select...

I don't know if this is possible, but I thought I ask I have a column with name Diameter in the records of the column I have the different dimensions in numbers 1,2,3 etc Is there a way to create a new value in another field that gives Diameter: 1 mm Diameter: 2 mm Diameter: 3 mm Just...

hello I am trying to run an update query on a database with about 12000 items First I run the query, get the message that it will update 12000 items and then I get a next screen which shows me the following message (my applogies for the translation :-) ) not all records in the update query...

Hello, I have a huge database (with 12000 lines) in which I would like to combine the values from 3 columns (fields) into a new column (field) Example: Group: 1234RP Size: 100 100 Grade: RPF Should become: ArticleCode 1234RP100100PRF Is...

Hello, I have two tables: InventoryTable Product Length Weight Trace number LocationsTable Product LocationA Min Length LocationA LocationB I now would like to combine the two tables in a query where the location which appears depends on the length of the product compared to the minimum...

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?

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...

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...

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 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 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...

I would like to make a human Resource database that shows in a tabbed form some informations about our employees. I would like to show per employee: tab 1: general info (name, address, starting date, type of contract, department) tab 2: salary history tab 3: capabilities -whether they are...

I have a table with 3 columns Order Date (f.e. 05/10/2006) Due Date (f.e. 09/10/2006) Ship Date (f.e. 10/10/2006) I would like to calculate: number of working days between order date and due date number of working days between due date and ship date Can someone help me with this one?:confused: