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

Hi, I am having problems copy and paste data for you, because this forum changes format. I tried to attach a file, but did not allow me. Helen

I want to see these: Client Name Order ID Unit Charging Rate Billing Start Date (but not the Contract Start Date) Billing End Date (Not Contract End Date) Contract End Date E.g. Report A: Billing Report 01/01/2014 - 10/02/2014--->The Billing Start Date is 01/01/2014, End Date is 10/02/2014

Could someone help, please!!!

Could anyone help, please!!!

ContractID Client StartDate EndDate DailyChargeUnit Contract A Client A 09/09/2013 09/09/2023 10 Contract B Client B 12/01/2014 31/12/2019 10 Contract C Client C 02/02/2014 02/02/2019 10 Contract D Client D 01/01/2013 31/01/2013 10 Require: Report A: 01/01/2014 - 10/02/2014 Report B...

Here you go: ContractIDClientNameStart DateEnd DateDaily Charge RateContract AClient A12/03/201312/03/2023£10.00Contract BClient B09/04/201309/04/2017£5.00Contract CClient C31/12/201231/12/2019£8.00Contract DClient D04/05/201304/05/2023£12.00Contract EClient E17/02/201417/02/2016£7.00Contract...

Hi Plog, The Billing Dates are not in any table. Because This is being typed in by a user. I only know the Contract Start and End dates and a Daily Charge Rate. e.g. Contract Name: AAA Start Date: 01/02/2014 End Date: 31/01/2024 Daily Charge Rate: £10 If I want to run a billing report...

Hi Plog, To answer your question, the Contract Start Date: 02/01/2014 End Date: 01/01/2019 Billing Date: it varies depending on user's requirement, it can be 31/01/2014, or 02/02/2014 or 31/12/2014 I used DateDiff, but a problem: the billing date changes depending on what user requests...

For example, Contract ABC,The contract term is 5 years. However, the billing report can be requested on any day e.g. Jan-2014 (01/01/2014-31/01/2014), Feb-2014(01/02/2014-28/02/2014), It also can be 01/03/2014-10/03/2014 (only 10 days billing report.). So I want to leave the billing START and...

I mean, I want to run Feb-2014 billing report (01/02/2014-28/02/2014) on any date as I like. I can run it on 03/03/2014 or even 03/03/2015. But I expect I have same report. The Billing run Start and End dates I leave if for user to type in every time before they require a report.

: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

Hi Bob, I am a learner for Access. I could not understand Nz() function by reading the formula on line. Could you write it for me? - I want to set up this in a field called 'Install Discount'. Many thanks

I try to avoid setting up these fields as 'Required' as this might be asking too much for some people. I have set the 'Default Value=0', but still did not work. - Any Idea?

Thank you. I now understand the reason. The database is open to everyone to use. What do I do to force Data Entry person to input Zero value, rather then leave it blank?

If no discount given: Order Table left blank(unfilled), Default is as NIL.

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