• 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:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Access 2007 IIF statement in query criteria

    This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought. It seems like I'm getting close but can't...

    Scubacy25 pointsBadges:
  • How to make Access 2007 database GUI

    I need help. I have created a small database, now my problem is I would like to build it in a more software-like interface. No more tools or any options of some sort from MS Access to display but only the navigation form which I designed. Is there any developer tools required? Thank you in advance!...

    Curiousnoob15 pointsBadges:
  • Access 2007 Database – Security Warning

    This database has come back to haunt me.... We recently changed out a computer and added a shortcut to the Access database. Actually it was the shortcut copied from the previous computer. When they double click the short cut, it takes them into the database menu as before. However, now it displays...

    LeChat80 pointsBadges:
  • Using a Linked Table to Create Auto Updating Excel Sheets

    I am having trouble figuring out if I can have one master spreadsheet in excel, link it to a database in access, apply filters to the master database, save the table, export it to excel, and still have it be linked to the master database? So I would only have to update the one master excel sheet.

    Caveman425 pointsBadges:
  • Create Button to Open Specific Form

    I have a continuous subform. I have added a command button beside each record on the subform to open another form, which is specific to that record. Every time I use the control wizard to make the button, the record I want is not opened. My relationship is Continuous ID to Button Number. I am not...

    a2rose2l5 pointsBadges:
  • IF and then statement in query

    I'm having issues with an if statement in a query. Basically I need to know how to get the following: If field 1 is > 0% then field 2 = 25. I don't know VBA

    tphester5 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 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:
  • MS Access 2007 functions

    Can someone please help me with the expression for the IFF function?

    TonnieSpartacas15 pointsBadges:
  • Access 2007 – All Access Object Forms Section – Collecting data using email

    In the forms section under the All Access Objects section, I am trying to collect data by using e-mail messages. I am trying to send this form out to a group of individuals and then I would want them to return that information to my email. From there I want to export that information from the form...

    JOrtiz895 pointsBadges:
  • How do you create an order form where you can enter multiple product line items?

    I am trying to make an order form in the data base for product.  I want this form to have customer ID and Company name once on the form then numerous qty, item name, and item number lines to be able to type more then one product ordered on the same order form.  I am having quite a bit of...

    PorcelainConfections10 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 2007

    How we add 26 years in today date and answer will be 19-03-2039?

    78678678678635 pointsBadges:
  • Access 2007 before update option

    For an input form, how to create a simple code for the before update option and notify user that the new entry number in already in the database.

    access15 pointsBadges:
  • Microsoft Access database design question

    I created a database. I am in the middle of populating with data but see some records that were inputted are no longer there. How can this happen?

    governmentgirl80 pointsBadges:
  • Form in Access 2007

    How to build a demand form which will draw grocery items from main inventory table with related data and quantity ordered will be filled up manually?

    pgd1235 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