• 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...

    MarvinM8015 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:
  • 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:
  • 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:
  • Access 2007 database query question

    I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd...

    JHartley10 pointsBadges:
  • Cumulative totals in Access 2003

    I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

    Acmaintainer20 pointsBadges:
  • Access 2007 Query Help

    I need some type of statement that will check my query results for a number in a field and then remove any instance of this item from my query. Example: I have multiple books in a table and I have an identifier field (1 = English, 2 = History, 3 = Science, etc...) where it can cause one book to...

    ThisGuy5 pointsBadges:
  • Access 2010 database query

    I am new to Access and am having some trouble writing a query, for an absentee database. I only have two tables, one for the roster and the other with the absentee logs. The Roster table only has employee name, badge number, and shift. The Attendance Log table has the date of occurrence, the...

    Katie5 pointsBadges:
  • How do I convert rows to columns in aAccess using Ms-access query(select statment)

    Hello all, please I want help with the following issue: I have the following table named "CHECKINOUT" in ms ACCESS            USERID      NAME        CHICKTIME           1          K1        5:45:11 AM           1          K1        3:45:12 AM       ...

    Ahejazi5 pointsBadges:
  • Access 2010 macros

    I have a macro that 1)starts with a make-table query, 2)opens a report based on the new table, then 3)runs an If statement stating IF [Reports]![Reject Report]!="NO" THEN EmailDatabaseObject called "Reject Report". . . My problem is that after the macro completes it locks the table that was made...

    Danna15 pointsBadges:
  • Creating Access Form

    I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.

    Tbill655 pointsBadges:
  • How can I email a query output from Access 2003?

    I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do so

    MahmoudAly5 pointsBadges:
  • Count IIF Statement?

    In the design of a query, I noticed that under the tab "Group By", there are only a few types of commands to make calculations. For example, the commands include Sum, Avg, Min, Max, Count, StDev, Var, First, Last, Expression, Where. Is it possible to have a special command? I'd like to use...

    Twj21025 pointsBadges:
  • Combining Access 2003 Queries for Dates Criteria

    I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a...

    GCIB15 pointsBadges:
  • Can an Access 2003 query exclude the results from a previous query?

    I have a database with 2 tables: one with name/address info, and another with info on yearly donations to our organization. The 2 tables are linked through an ID number. I have set up a query that will give me name/address info for those who donated in 2010 (where the year field is 2010 and the...

    Susan3955 pointsBadges:
  • Creating Automatic Notifications in Access 2007

    I am building a volunteer database. I have a table tracking hours that each volunteer has put in, and would like to be notified when they reach certain milestones, (eg, 25 hours, 50 hours, 100 hours), so that we know who to thank appropriately. I believe that I will need a query totaling the hours...

    MeowGina10 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