Billing Rate

Aug 28, 2006

Hello all,

I am talking to a potential customer about doing some contract work using access. This would be my first contract using access and I was just curious what some of you are charging as your rate. I'm a strong developer but my experience has been in a full-time position so I'm not sure what contractors would get paid.

Any help would be appreciated!

View Replies


ADVERTISEMENT

Best Way To Maintain Billing Rate History?

Feb 16, 2008

I have created a table for customer bills, and a table for customer profiles which contains rates associated with them specifically. The problem is that after a new rate change has been imposed I want to be able to look at an old bill, via a report, and have it reflect the "old" rate within proper historical context. I'm looking for suggestions on how to best manage ongoing rate changes while maintaining a billing rate history in my reports?

View 6 Replies View Related

Time & Billing Beta 1

Jan 14, 2007

I've now decide to release this project as it now does All I want and thanks to all those from hear who helped with some of the solutions to my problems I'm happy with it.There are some items that have been disabled this is only because I don't need them at the min but when added I'll update the file, The tables are as complete as can be although there will be addition for later versionsThis version is for 2003 should you require 2002 please post a request for it.There will be additional tables as this project develops plus as I don't really use a lot of reports I've only added what I need but if you have a suggestion for a report let me know I will be adding a few as things develop.Thanks to Kent Telephones (http://www.k8t.co.uk) for hosting this project.IMPORTANT READ THE GETTING STARTED FOR SETTING UP AND INSTALLING THE SMTP DLL WHICH IS REQUIRED FOR THIS PROJECT TO RUN.Enjoyhttp://www.databasedreams.co.uk/freeware.html

View 14 Replies View Related

Check Box - Same As Billing Address

Apr 24, 2014

I have a form asking for a billing address and a service address. Many times these will be the same. I added a check box to check to populate the following fields; Service Address, Service City, Service State, Service Zip.

Fields that it will be coming from are the same, just named Billing instead of service. Tried expression builder and macro builder with no luck.

View 2 Replies View Related

Calculate Days Between Billing Dates

Oct 6, 2005

I am woking on a project full of nightmares. My latest, and the one I am currently unable to solve, involves trying to calculate the number of days between Billing Dates.

I have a table named "Date" - I didn't design this!
It contains a field named "Date"

If I query for just that Field I get the following:
Date
9/8/2005
8/8/2005
7/8/2005
6/8/2005
5/9/2005
...

I need to figure out a way to determine the number of days between the bills so I can calculate the average cost per day.

It seems like it should be an easy thing using like the datediff function or something, but since they are in separate records (rows), I can't figure it out. I have tried and tried and tried.

Any suggestions would be VERY much appreciated.

View 3 Replies View Related

Desktop Time And Billing Template With VAT

Nov 12, 2013

I have a very simple database using the MS template 'desktop time and billing' for MS Access 2007.

[URL] .....

Any new template with the option for VAT or Sales Tax for each Billable Hour and each Billable Expense?

If this is selected or overwritten at time /expense input stage and then automatically added to the invoice.

Not sure why MS omitted Sales Tax from their design?!

Can Access Master add Sales Tax /VAT and then post as a new template?

View 3 Replies View Related

General :: Create Time Billing Form

Aug 2, 2014

What I am trying to do, is create a time billing form to track time spent on different tasks, with the following items in a neat form, in this format:

1) Client
2) Employee
3) Rate/hour
4) Date
5) StartTime
6) EndTime
7) BillableHours (*)

I am able to make a form that correctly works lets the user enter records for 1-6, with the user pressing crtl+shft+; to give the correct starttime, and then at the end of the task, the user can press the same and register the end of the task.

My problem is that I can't work out how to calculate 7) as one needs to input some VBA code that converts date/time to numeric values, allowing you to calculate time difference. However, I simply don't know; a) the proper 'code' that will calculate the time different between 5) and 6). I saw that it was perhaps the dateDiff command? And b) where I would even put that code into, i.e. the exact location where one goes to and types the code into... Is it a query? Do you set it to a Calculated value in the table editor?

View 7 Replies View Related

Modules & VBA :: Automation - Create Billing Periods For Project Duration

Nov 19, 2013

I developed a finance tracker database for tracking project revenues and costs (forecast and actual amounts). I have a form where we enter a new Work Order in the DB. This Work Order form has a continous subform where we create all the billing periods needed for the life of the Work Order. Once the billing periods are created (opened) we can then add our revenue and cost forecasts for each period. We have a Billing Period lookup table that has our billing periods with their respective start and end dates (which usually begin around the last week of a month and end about 3 weeks into the next month).

For the purpose of this question, lets say we only enter the required WO_Number and WBS_Code (Composite key) and the Work Order Start_Date and End_Date. I want to click a button to runs some code to automatically create all the billing periods for which their start and end dates fall into the Work Order start and end dates.

For example, say a Work Order starts on 5/1/2013 and ends on 7/31/2013

The billing period dates in the Billing Periods lookup table are as follows:
May-13 ---> 4/22/2013 - 5/19/2013
Jun-13 ---> 5/20/2013 - 6/23/2013
Jul-13 ---> 6/24/2013 - 7/21/2013
Aug-13 ---> 7/22/2013 - 8/18/2013

Then we would need the following billing periods created in the Work Order subform:
May-13
Jun-13
Jul-13
Aug-13

I don't even know where to start on this. Is it possible to automate this process with the setup I have? If so, how would I structure the VBA code/logic to use the billing period lookup table and create entries in the subform for all the billing periods that fall into the duration of the Work Order.

The attached DB is a stripped down version with only the tables and forms needed for this problem.

View 2 Replies View Related

Rate My DB

Mar 23, 2008

Hoi, Well, this is my 1st EVER database and whatever I've learnt is either from here or 'on-the-way'..It's a Libr4ry Database for a college assignment.Basically, I'm a DBA and also an employee at the library.Nurseries come to us/me to hire books for their students/children/whatever.In my DB you canAdd Authors (of books)Add Books Add copies of booksAdd NurseriesDelete authorsdelete booksdelete nurseriesLoan booksReserve booksReturn booksview all authors reportview all booksview all nurseriesview current loansview current reservationsI've attached my DB, have a little play around say what you think about it..I know at the moment there are a few issues: Adding a copy of a book is annoying because you have to add the book first and then go into an other form and add it as many times as you have it. On Loan report you can't see whether or not the book has been returned Authors_ID are stupidly HIGH and i have no idea why? Autonumber 1,2,3-100? No! 1,2,3,4120032,4120033,4120034 etc! Books can be loaned MANY times Reservations can be made MANY times with the same book Can't view the stock level on a book (haven't done this yet) RETURN table doesn't show necessary data such as names of book and nursery just their ID's which can cause confusion RETURN table 'returned?' combo box shows 0/1 instead of Yes/No although Yes/No are in the drop down box it'sself.. LOAN Table 'date due back' textbox shows '#error' when there isn't a date entered in the Loan date textbox..That list isn't conclusive :' )I'll probably find loads more thing wrong with it..But, if you could..just gimme your feedback and what COULD be improved.. and what's sh-t and what's not etc.Database password is my username.Cheers for all the help with it guys/guyesses!:D:DEDIT: if problems opening .zip, rename it too whatever.rar.

View 11 Replies View Related

Exchange Rate

Jun 18, 2007

Hey guys,

I have a form that works out the cost of products from £ to € by calcuation where the user puts in the current exchange rate into an unbound text field.

i was wondering is this is at all possible:
to get the current exchange rate automatically off the internet from some kind of website

i would love to hear suggestions.. what kind of problems i am likley to encounter or if any one has attempted or succesfully managed to do this or something similar.

View 4 Replies View Related

Exchange Rate Problem

Sep 17, 2005

I've got a question about MS Access.

I've got a table with different customers and different rates that they offer for certain products. The problem is that different customers deal in different currencies. The currencies are one of three; Euro's, Pounds or Dollars.

I would like to create a query that would convert each customers rates to the same currency (pound).

The information is divided into 2 different tables. A customer table and a product table. I've created a form that is based on the customer table and features the product table as a sub-form.

What I would like to do is have an option that would enable me to enter the current exchange rates (as they are constantly changing) which would be used to convert the individual rates depending on the currency used by customers.

Form fields as follows

- cust_id
- cust_name
- company_name
- company_add1
- company_add2
- company_pc
- company_country

sub-form

- prod_id
- prod_name
- currency
- prod_rate
- convert

I'm sure this is possible, but my knowledge on this matter is limitted.

Thanks in advance for any advice given.

View 1 Replies View Related

Calculate Rate Between Date

Sep 27, 2007

Hi All.
In my employee's table I have EmployeeName, Rate, Date and I need create query to calculate Rate for each eployee between Date if ration during this period of time was diferent.
Thanks.

View 1 Replies View Related

Connect Rate With Description.

Feb 10, 2005

I was wondering if it would be possible to type in a description eg.(Days, nights, O.T.,ect.) and have excell automatically insert the rate I specify into another cell.

View 1 Replies View Related

Hourly Rate Of Pay For Access Development

Nov 8, 2005

I am self-taught on Access and have designed a quite basic database for a friend who owns his own company. This is a client contact database designed to hold information about his clients and their companies, but also to send reminders to Outlook when they haven't been contacted for a while - ie. to make my friend more proactive in his business.

This was a project which I originally agreed to work on for a fixed price. Needless to say, I undersold myself and probably because I am self-taught, with the number of hours I have put in, I probably got paid 2p an hour!

The project is drawing to a close, but he wants to pay me per hour for any further development to the system, and for any similar work he wants doing, problem is I haven't a clue what to charge him per hour?

Any ideas, without divulging your well-earned salaries of course!

View 8 Replies View Related

Calculating Depending On The Currency & F/x Rate

Jan 13, 2006

Hi,

I have a query in which I try to calculate field values depending on the currency and foreign exchange rates.
I have a currency field with the amount value and a combo box where I select the currency for that amount which can be (USD, Euro, BRL, or INR). I have got also another 4 fields with each of currency foreign exchange rates.
I am trying to obtain in a new calculated field of Price in Euros if the amount I have in the 1st field is not already in Euros.

Say:

Field 1 Field 2 Field 3
amount currency F/rate


2000 in USD or Euro or BRL or INR 0.8754
depending what is selected
in combo box.


Field 3

Result

field1 * field 3 in Euro depending currency selected in field 2

Can anyone help, plese?

thank you

dfuas

View 10 Replies View Related

Using Country Field To Determine VAT Rate.

May 9, 2007

hey,

i have a customer form which includes a "Country" combo box.. the reason i did this is because i have a separate table with a list of countries and their VAT (Value Added Tax, you americans call it sales tax i think :)) rates.

i want this country saved in the customers table.. i need the country table to act merely as a source of data. Now ive spent a good hour tying to fix it messing around with the relationship between the two tables and the combo box itself.. but ive only been able to come to two end results

a) access tells me i cant save the new customer record cause a related record is required in the country table.

b) access enters a new line in my country table with the autonumber of the country selected on the add new customer form in the Country field.

im stumped as to where the problem is:// how can i fix it?

View 5 Replies View Related

Tables :: Event ID - Show Tax Rate

Jul 9, 2015

I have a tblShowCosts and in that has the Event ID and the Show tax rate. In my tblShowSales I want access to take the subtotal and times it by that shows tax. Not sure how to tell access if the Show name = such-and-such then times it by the Tax Rate.

View 14 Replies View Related

Using Most Current Employee Wage Rate

May 18, 2015

I am setting up a time tracking database which will track employees maintenance times. Several employees spend X number of hours each day maintaining machines from different categories, such as mowing, snow removal, etc.

I am trying to figure out if it is possible to set the tables up in a way which will not require adding an employees wage rate to every time tracking (listed in the time tracking table below) record. To somehow have the table pull data from the most recent wage record for that particular employee. As employees get raises I would like to retain the old rate in the time tracking table along with the new rate for current data.

The way I have the tables setup right now are as follows.

Employee table
EmployeeIDFirstNameLastNameAddress, Phone, etc

Maintenance Categories table
MaintIDMaintName

Wage table

WageIDEmployeeIDDateEffectiveCurrentWage

Time Tracking table

TimeTrackingIDEmployeeID (lookup from employee table)MaintID (lookup from maintenance table)WageID (lookup from the wage table)DateOfMaintenanceStartTimeEndTime

All of the tables have relationships in the time tracking table.

View 3 Replies View Related

Concerning Prices: Hourly Rate / One-time Amount

Mar 26, 2008

I'm asked to do a specific task, a database concerning of:Tables: 25Forms: 25Reports: 40-45Build from ground up, multi-user, accounts, account-restrictions, has to be linked to an already existing database, will need a fair amount of VBA coding.I would like to know specifically two things:--> what is your common hourly rate --> what would your common total-price-estimate for a project like this.

View 1 Replies View Related

Reports :: Hourly Rate - Calculated Totals Not Adding Up

Sep 5, 2013

We recently have had a change to our hourly rate that we pay and now the Totals calculation is not adding up the numbers correctly.

In the query that the report is based from:

ExtendedTotal: CCur([Hours]*[Rate])

In the footer of the report: (Provides a Total for each Day)

Sub-Total: "Control Source" is: =Sum(CCur([ExtendedTotal]))

Report Footer: (Provides a Grand Total for the Month)
Total: "Control Source" is: =Sum([ExtendedTotal])

Problem comes in with the odd dollar rate time partial hours. For example:

$9.73 x 4.5 hours = $43.785 (Rounds to $43.79) which is fine...

but when you have a whole column of these rounded numbers, the totals are coming out off by pennies which add up to a good bit at the end of the month. I cannot match up the totals with the invoices that are coming in either.

View 14 Replies View Related

Queries :: Average Call Rate - Determine If Trend Is Up Or Down

Jun 28, 2013

I have a query that displays the average call rate on various pieces of equipment over the last 12 months. I was wondering if there is a way to have Access look at this query and determine if the call rates are trending up or down over that time frame. Kind of like a trend line would do on a chart in Excel, only I want this to show me the word Up or Down in my results. Is this possible?

Here is the query I am using:

Code:
TRANSFORM FormatNumber(Avg([All Call Rate]),2) AS AvgCallRate
SELECT List_With_TNC_tbl.Device, List_With_TNC_tbl.Model, List_With_TNC_tbl.[Item Num]
FROM List_With_TNC_tbl
GROUP BY List_With_TNC_tbl.Device, List_With_TNC_tbl.Model, List_With_TNC_tbl.[Item Num]
PIVOT Format([Month Start Date],"mmm") In ("Jan","Feb","Mar","Apr","May", "Jun", "Jul","Aug","Sep", "Oct", "Nov", "Dec");

View 3 Replies View Related

Tables :: Relating Transactions With Rate Master Table

Jan 28, 2013

I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants developing a much faster and customized approach to billing the customer based on payroll related information.

There is a table of payroll billing transactions and it has the following record lay-out,

job_num, employee number, employee name, union group, rank, regular hours, overtime hours, other hours, trans_date, seq_num

6430, 2301, john doe, 1, F, 8.0, 0.0, 0.0, 12/01/2012, 254333

On December 1st John Doe worked 8.0 regular hours as a pipefitter foreman on job number 6430 and this is record (sequence) number 254333.

There is another table that defines the union group. I am not concerned with this information at this time. The seq_num is a sequentially and uniquely assigned number given to each billing record in the main system.

There is also a Rate Master table and it has the following record layout,

job_num, union group, rank, regular_billing_rate, overtime_billing_rate, other_billing_rate

I am struggling as to how to relate these two tables so that I can develop some queries from it.

View 2 Replies View Related

General :: Rate Calculation Over Period Of Time - MDB Format

Jan 29, 2014

Calculating the rates over a period of time. I think the attachment will give you a clear picture of what I am looking for.

To get the cost for a particular period I want the rates to be updated as per the given period. How I could get the calculation in the mdb format...

View 4 Replies View Related

General :: Lookup Criteria - Rate To Calculate Salary

Sep 6, 2012

I have one table with employees and positions. Each position has a specific rate which is stored in another table (table2). Since the rates of the positions are changing, I want each time the employee get paid with the correct rate.

The problem is that I do not want to lose historic data since I want the rate to calculate the salary. I thought that the best way is to look up for the rate according to the position and the period that is valid.

I have attached herewith a small example with the two table that I want to use the relationship.

View 3 Replies View Related

Employee Payroll Forecasting - How To Account For Change In Pay Rate

Aug 27, 2014

I have a table called tbl_Employee. The employee's hourly rate is one of the columns. I want to create a forecasting schedule that will find the work days between two dates, multiply by 8 (hours per day) and multiply by the hourly rate.

For example, Employee A has rate of $100/hr. We forecast they will work 250 work days from January 1, 2014 to January 1, 2015 so 250*8*100= $200,000.

However, on June 1, the rate for Employee A increases to $110. So the new forecast would be (125*8*100)+(125*8*110)=(100,000+110,000)=$210,000 .

How can I account for something like this?

View 2 Replies View Related

General :: Determine Rate For Charging Application Maintenance And Support Fees

Aug 17, 2013

I've built and implemented an Access 2010 application for a corporate client. It's entirely menu driven, with no user access to the navigation pane. It's split with multiple BEs on a share drive and the FEs on individual PCs (distributed via Auto FE Updater). Two hundred users have been defined to the application but so far there are only up to 10 max concurrent users at a time.

The clients want to add more users to the system but after that will go into maintenance and support mode. The question is how much I should charge for the maintenance and support service on a monthly basis.

I'm not looking for a $ amount as much as strategies/guidelines for pricing. The clients anticipate using the application for about four years, at which point a new, corporate-wide application should be rolled out and my app will get replaced by it. They will probably need to convert the data from my app into the new app, and will want/need occasional enhancements to the system over the next four years as well.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved