Recent content by Tkandy

Hi I have a Data being recieved to a excel spreadsheet at 6am, i would like to copy this data automatically to database. I started with just one cell to start with but it it not working what VB i have tried is in the attachment

I need to put a contol on a Db that makes sure there is a entry for every day. I have [date] and [well reading] in the table.

Thank you i will try to see if i can do these :)

I would like to produce a graph which has a year to date usage and a trendline of what we should not exceed. I know how to do graphs but i cannot seem to get the query to run correctly We document at the moment a daily reading [Date] [Well1] [Well 2] In a query i have got the daily...

I am only a beginner at Access, and have got a report i send out every month and it is consists of lots of subreports, I email this out as a PDF at the moment but would like to be able to send it out in excel, when i try it will only do the first Subreport. i would also like to keep all the...

I have a table which we are allowed to use 35000 cubic metres of water in a 7 day period, from all the wells. listed below [WellID][WellsDate][well4][well9][well5][well10][well12] they enter usage in a form need it to be able to calculate usage (average used?0 and give error if we are...

From your start date at salary increment on a monthly basis Annual Leave and Sick leave Then from your actual start date with the company of 10 / 15 and 20 years you get a bonus one off entitlement of a week holiday

[Start date Company] [Start Date] [Salary] [LB start Date] [Leave Balance] [Toil Balance] [Sick Leave] [LS Leave] You may start at this company [Start Date Company] but you may not be salary staff till a later date, hence having the [Start Date] because that is when you start accruing leave...

I have inherited a database at work for the accrual of annual leave at the moment they input it manually, but would like this to auto incrament every month on our financial month. these are the fields [First Name] [Surname] [Department] [Position] [Start date...

First NameSurnameDepartmentPositionStart date CompanyStart Date SalaryLB start DateLeave BalanceToil BalanceSick LeaveLS Leave I have inhearited a database which they now want me to look at they are wanting to automatically incriment the holiday entitlement. can someone help me please

Thank you so much for your guys help it is really much appreciated as i have been chucked in the deep end to do this i am going to have a read up and change some of my tables and i will get back to you on how i am doing. Once again thank you for taking the time to help me on this massive...

Thank you jzwp22 for replying i hope i explain this a bit better I have built this on what our company uses and we are trying to track the readings of daily usage and weekly usage. I have set the tables up as Electricity readings, well readings, boiler room readings, water consumption. with...

Help Me please I have designed a database which has a current date 1 field and a well reading (Readings) 9 fields which goes something like this [WellsDate] [MainMeter] [GasMeter] [Well 4] [Well 5] [Well 9][Well 10][Well 12] [Well 14][Rendering Heat] I am trying to subtract the readings...

Hi Paul you have given someone a solution "ways to calculate difference between numerical records." I am very new at this you mentioned to use SQL and this was the SELECT MeterReadings.MeterID, MeterReadings.Date, MeterReadings.Reading, (SELECT Reading FROM MeterReadings AS Alias WHERE...