Search results

I have two tables(see below). I want to set up a query, link these 2 tables together. I set a one-to-one relationship between Client ID in two table. But got error message :"Type mismatch in expression". I tried to change Client ID data type from "Text" to "Number", then Access deleted some...

:banghead:I have a Contract Table: Order ID Client Name Unit Daily Rate in GBP No of Unit Contract Start Date Contract End Date Requirement: To run a billing run every Month End. e.g. I will be running Feb-2014 billing report on 03-March-2014. This mean every month Billing End Date is...

Help!!! I imported data from Excel to create a new Table called 'Installs' by using Import Spreadsheet Wizard. During the process, I changed 2 Fields: 'OrderID' and 'IMEI' data type to be 'Long Integer'. But Access decided to delete ALL data under this two headings. I need to change these...

I want to design a query: I want a contract START_DATE eg 18.03.2014, the contract LENGTH is 60 months, what date is the end date of the contract. Helen

I have a Order Table: Order ID(Autonumber) Client ID(Text) Client Name(Short Text) Install Gross Rate (Currency) Install Discount Given in % (Number) Install Discount Given in GBP (Currency) Then I designed a Query to calculate the Install Net Rate Query I selected Client ID Client Name...