Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / April 2008

Tip: Looking for answers? Try searching our database.

Query Selection and Criteria

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
AJRoad - 25 Apr 2008 20:59 GMT
I would like to make a query that shows a 10% deposit for each job in my jobs
table. I would also like to include the Job ID, Customer ID and deposit
amount field for every record in my table. Can someone please help me, it's
probably something really easy, but I have been struggling with this and can
not seem to get it to work. I am using Access 2007.

Thanks,

AJRoad
Evi - 25 Apr 2008 22:06 GMT
You should have

Remember, we can't see your database - you didn't mention the field name of
which we need to find 10% . I'll call it JobAmount. JobAmount may be a field
in a Totals query if you are adding up everything you need for your job.

I recommend that you have a field in your Jobs table called DeposPerc where
you store the 10 (I'd make it a number field rather than a percent - it's
easier to manage.). Don't put it in your calculation because if you decide
to change your deposit percentage it will make your past records wrong.

The calculation in your query is
Deposit: JobAmount * ([DeposPerc]/100)
Don't store the results of  calculations in your table however, just in your
query. Here, it will be available for display in forms and reports. If you
store it in your table and then change one of the values that add up to
JobAmount, your data in your table will be wrong
Evi

Treat your table as a bucket where you store your data.
> I would like to make a query that shows a 10% deposit for each job in my jobs
> table. I would also like to include the Job ID, Customer ID and deposit
[quoted text clipped - 5 lines]
>
> AJRoad
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.