Search results

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

this did the trick. THANKS !!!!

First let me appologize for being a total noob, but where do I enter this code??? Is this in the query?

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:

I have made several extractions from back ups from our ERP system using maketable querys. Each time when I renamed the table after running the maketable query. I now want to add them to create one big table showing the records which I extracted. I now found that each time when I extracted from...

thanks for the hint. I found the list of exsisting specs under the advanced button and were able to change the type of one of the fields

Probably not the best Title but I have a database where I import data and there seem to be some specs for the import (see below), but I cannot find those. Private Sub Button1_Click() Dim stDocName As String DoCmd.SetWarnings False stDocName = "Query1" DoCmd.OpenQuery "Query1"...

I am not sure if this is possible so here it goes: I have been writing a little query that collects data to batchprint invoices. I want to add some criteria for the user I have one criteria on the invoice date: between [start date] and [end date] and I want to add one criteria for the invoice...

what I would like is to click the print button ones and then an original (which should appear on the document) and a copy (als to appear on the invoice) should come out

I have a query that shows as outcome all invoices and its details per date (date is chosen by user) My idea was to make an Invoice report that shows all these details. I have one major prolem (even if using the wizard) that I cannot get a good result. I want: Report to be grouped by Invoice...

Thanks !! Removing the " " around the 1 did the trick. And again I have learned something :)

In my query I have the folowing expression: Currency: Iif([Exch]="1";"Szt";"Eur") - if the exchange rate is 1 then the currency is Zlotty if different from 1 then it's Euro When I run the query it returns "#Error" ? Anyone have an idea to fix this?

I have a made a little DB that collects data and prints it on an invoice. I would like to print 1 original and 1 copy (or 2 copies if needed in the future) Anyone have an idea how I can achieve this (the easiest possible way). I have been thinking of subs-reports but it seems somewhat difficult

I have a query where I have some negative numbers (f.e. -403,26) which I like to make a positive (i.e. 403,26). How do I do this??

Hi, I want to make a query where I have 2 tables: Table 1: Purchase Orders Customer A Table 2: Sales Order Supplier B In the query I link the PO number out of Table 1 with the customer ref field in Table 2. I get an error message because the types of field don't seem to match. After some...

I have a query which has a field where it shows reservations. if there is no reservation the field is empty. how can I achieve getting a 0 in this field when it is empty?

found the solution instead of using the commas I use a ; in the query builder and it worked?? anyway, thanks very much for all the leads

I get an error message when using this expression: "The expression you entered contains an invalid syntax. You omitted an operant or operator, you entered and invalid character or comma, or you entered text without surrounding it in quotation marks "

I have a table with products and their costs per unit of measure. some products are costed by weight and others by piece. table looks something like this: product pcs weight unit of measure (EA or KGS) cost Query should look like this: product pcs weight Total Cost Is it possible to write...

Hi, I have a long list of customers / suppliers and their VAT numbers. I would like to create a query that shows only the customer/supplier number and the first 2 characters (countrycode) from their VAT number. for example Supplier 3 VAT number NL80980808 endresult should show: 3...