1
  • Access 2007 database reports

    I am converting our Access Database to a new fiscal year and have an encumbrance report that is supposed to start picking up services starting 7/1/2014 and it is calculating from the beginning of the placement, ie before 7/1/14 not after. The other report with the same formula is working fine. I...

    ci05215 pointsBadges:
  • Equations in Microsoft Access

    I have a database that contains species, height and diameter for 1000's of trees. I need to create a query that calculates the volume of each tree using a different and complicated equation for each species (there are approximately 8 different equations to use). I thought about writing a...

    richalds5 pointsBadges:
  • Left justifying in a query

    The numeric field in my table is left justified and works fine but any queries I use with that field end up being right justified. Is there a simple fix for this.

    posker5 pointsBadges:
  • Access 2003 parameter query bollixed

    The query searches a table looking for three fields, one of which is the Year. The year parameter request works just fine [Year as yyyy]. The query then goes on and asks for a second parameter for a field that was not included as a requested field. Any hints given are appreciated - thank you wem3rd

    wem3rd65 pointsBadges:
  • Teacher’s salaries

    I created a database for contracts using Access 2003. I changed a calculation in a form that was created and it works on the form, but when I open a query it's still displaying the old totals from the old calculation method. What do I need to do to make it change in the query also?

    Smith35 pointsBadges:
  • Access 2007 query with null values

    I am currently creating an Access 2007 database for calculating salesperson commissions. I have a table with 5 fields I'm working with: SalesRep, SOWRep, TerritoryRep, Period and Commission. I am trying to build a query that will calculate commission for a salesperson for each record where their...

    stlawr45 pointsBadges:
  • Need help writing query-I’m stumped!

    I have a table that looks like this: ID EEID DR CR 1 333 30 2 333 50 3 333 30 4 333 30 5 444 60 6 444 60 7 444 70 ID is my primary key column and it auto numbers the records. EEID is a person, and there are many records per one person. DR is a debit entry for that person, CR is a credit entry for...

    kmanette45 pointsBadges:
  • MS Access 2008 calculation in query

    How can I produce total marks for only last three column where is my fields and result will be:- ID 2004 2005 2006 2007 2008 2009 2010 2011 2012 Total Marks 1 6 6 6 8 0 0 0 0 0 20 2 10 10 0 10 0 8 0 8 8 24 3 6 6 6 10 10 0 0 10 0 30 4 0 0 6 10 10 10 0 10 8 28 5 0 0 2 6 6 8 0 0 0 20 6 0 0 0 8 10 8 0...

    78678678678635 pointsBadges:
  • How to combine 2 linked Excel tables in access 2003 with same field names, using query?

    I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

    Accesstables5 pointsBadges:
  • Query for a Mail Merge

    When I access my Auction Query in Access I can pull it up and everyone is there. When I try to do a mail merge and pull up my auction query all the other queries are there except the auction query.

    4hcandles5 pointsBadges:
  • MS Access query to show records that contain dates that differ by 1 year

    I have a table that is composed of 15 date fields. I want to make a query that will show the records where the there is a year difference between any of the 15 dates. I know that you can use the datediff function but that can only be used for 2 dates at a time. To create a datediff function for all...

    SerenityNow365 pointsBadges:
  • Grouping Query

    I have a csv file which is exported from another system each day. The file contains various IP addresses with associated usage. ex Address Usage 10.15.22.198 1,200,000 10.15.22.198 1,100,000 10.22.15.194 950,000 10.52.18.187 911,000 10.26.12.194 901,000 10.57.83.187 850,000 I need to write a query...

    Mmak5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following