• MS Access query

    I have a large table for a leasing database, and it includes a column for start dates and end dates of lease terms, and there are up to 11 lease terms. I am trying to write a query that will identify the current lease term, and then another query to identify the current rent rate based on which...

    kgonzales20 pointsBadges:
  • Determining data from a certain date range

    I have an Access 2003 database that has weekly dates and weights enter for a weight loss program. Ech program session is 8 weeks and people sign up for anywhere from 1 to many more sessions at a time. I want to find out the average weight lost in the first 8 weeks that a patient belongs, then in 16...

    HSwartzPartners65 pointsBadges:
  • Image capture and store into Sql Server 2005 code in vb 6

    how to store image in Sql Server 2005 by using visual basic 6

    nishantganapa0 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:
  • Count characters for each string in a column of data

    Within MS Access 2003 I want to create a column of data containing the results of a count. The count needs to tell me the string length of each data element in an adjacent Field. So, if for example I had a Field containing people's surnames, and I want to see, for each surname, the string length...

    AADataExec5 pointsBadges:
  • Late Bound Listview in Access

    Not sure if this will make sense, but here goes: I have several forms built which include listview controls on them. I am currently using early binding to manipulate them, but one of my user's workstations is having an issue reading the ref lib. I'm assuming there is a program on that system that...

    McNitro255 pointsBadges:
  • Getting last 6 entries for each person

    Hi everyone, I am trying to create a query that pulls the last 6 exam scores for each of the operators at the plant I work at.  I have a table that has the last 2-3 years worth of data.  The current query I have just organizes the data without filtering the last 6 entries, and I cannot figure out...

    DASiuda25 pointsBadges:
  • Passing a form to subroutine in Access 2003 (VBA)

    I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all...

    Nainey5 pointsBadges:
  • Access 2003 SQL Query for grouping

    Team... I need your help... SELECT Pickerid, Sum(Currentweight) AS TotalWeight, IIf(pickerhours=0,0,TotalWeight/pickerhours) FROM mergeddatabase WHERE ((Currentdate) between [Enter First Date Required:] and [Enter Last Date Required:]) GROUP BY pickerid, pickerhours; I have a access database (2003)...

    witsendestate225 pointsBadges:
  • OLE object

    The Access form will not accept olebound .jpg pictures. The form is referencing a table with an OLE Object field definition. The picture frame on the form is created using OLEbound object frame. When using Insert Object' and finding the file containing the .jpg picture, only the jpg tag and the...

    Bocaj735 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:
  • access 2003 mdb file size increases automatically

    please if you can tell me why size of an access 2003 file automatically increase whereas no data is entered or very less data. it increases upto more than 1 GB. once the same data is imported into another file it is of the size of about 20-30 mb. strange? i have used anti viruses but in vain. plz...

    MKhalidM5 pointsBadges:
  • access 2003 complex query

    Master table has fields: Report_No,Product_ID,Test_Date Detail table has fields: Report_Det,Report_No(Foreign key),Serial_No,Quantity,Result Results table has records: Pass,Fail,R&D,InProcess Detail table have 1,2 or 3 records with different result against each record in Master table. I want to...

    Isqureshi665 pointsBadges:
  • Create “if then” formula in Access 2003

    Hello, I'm new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that's why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one for intro and...

    Jos197215 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 2003 report printing

    We've been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we've used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the printer icon. The...

    tlsanders11,340 pointsBadges:
  • User Accounts in Access 2003

    I set up successfully user accounts and passwords in MS Access 2003 on my computer. when I transfer the file to another computer the login form no longer comes.

    Muwambo5 pointsBadges:
  • DoCmd.OpenReport not working right with WHERE clause

    I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As...

    Pubfin15 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • How to count data in Access 2003 stored database

    hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you

    Tlosom55 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