• 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:
  • Handling Record Update Collisions

    I have a split database. A form on the front end allows users to input their updates and then press a "Save" button to send their updates to the back end database. If two users simultaneously try to update the same record, one will connect, lock the record, and the change is committed. The other...

    MarvinM8050 pointsBadges:
  • AS/400 via Access, update query

    Hi all, My DB is on AS/400 and I use Microsoft Access to run queries. However, whenever I try to run an update query, I receive the following error message: "[IBM][ISeries Access ODBC Driver][DB2 UDB]SQL7008 - table in library not valid for operation. (#-7008)" Any idea what is missing? Thanks in...

    Antser5 pointsBadges:
  • How to use lookup query to return only entries matching the related field of active record

    I'm creating a lookup field and would like to list only those items relevant to the record actively using the lookup. So my DB has two tables one using the lookup which as a child ID field that I'd like to match with the parent ID field of another table.

    YesMayhem5 pointsBadges:
  • Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • Query by character length in Access 2007

    I want to see all the records with 3 or less characters in a specific field. My field contains both text and numbers. How can I do this?

    Skb195510 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:
  • OLE field in UNION query

    I need to join 2 tables, each with a field with an OLE object data type, in a UNION query in MS Access, but I get the message that an OLE field cannot be used in the Select clause of a union query. Does anyone know a work-around?

    Mlwonio90 pointsBadges:
  • MS Access 2007 Date Query Question

    My question is 2 parts: 1) I need to build a query that will look for dates in a date field that are >= 4 1/2 years from a date specified by the user. For example, if the user enters Sep 2011 the query would return all records in the database that are 4 1/2 years older than the specified date...

    Smidkiff55 pointsBadges:
  • Query for records that have certain numbers in them

    I have a table with 4 fields and 100 records(rows), with numbers in each field. Example would be: In Record One Fieldone has 87 fieldtwo has 94 fieldthree has 32 fieldfour has 99. than Record two has numbers in each field: Fieldone-94, Fieldtwo-33, Fieldthree-102, Fieldfour-44. I need to create a...

    Dnsnb25 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:
  • Writing to multiple fields with one text box

    I am trying to find a way to get a single text box to write to multiple fields within a table. The reason I want to do this is for graphing purposes (with an outside source) and to not over crowd/complicate a form for the operators who will be using it. If this is not possible is there a way to...

    Manalyn35 pointsBadges:
  • max query expression

    have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

    Mwatters5 pointsBadges:

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