• MS Access 2007 IIF expression

    I have multiple court dates tied to a client. I have a query created to pull the records. Right now, it's pulling all records with all court dates that is greater than today's date. I want the report to show just the next court date for each client. Is there an expression can I use to show only the...

    BaMbI0530 pointsBadges:
  • Access 2003 – command button to show query in pivot format

    I have a form with a comman button.  I want the user to be brought to a query when they press the button.  The query is built in a pivot table format, but when accessed by the command button, it appears as a datatable instead.  What am I doing wrong?

    Smbecker5 pointsBadges:
  • Basic Access Database query question

    I have an "Early voter list" table that I queried for matches against a "Dem Voters" table with the results generating a new "Identified Early Dems" table.   I would now like to query the "Identified Early Dems" table against the original "Early voter" table and be left with a table of "Early...

    Sharx2th5 pointsBadges:
  • DB Table/Query Layout for Ranking System

    Hello, I'm building a Membership DB where Members can achieve certain ranks (Rank1 - Rank14). I would like to present two things: - a list of all Members with their current rank and the Date the rank was achieved - for each Member a list of their ranks and the corresponding dates of achieving them....

    Artificial15 pointsBadges:
  • Subquery in Microsoft Access

    [em]   Trying to create a subquery for a table in Access.   I am trying to pull out of a table all records where Sales amount is greater than 1000 and the discount rate is less than 5%. I have to calcuate the discount percentage in the  table, and don't want to create another table with that...

    Miltonfung5 pointsBadges:
  • Query that uses input data from another form

    OK..I need to query a data form that is set to extract data from one table, but I have other fields on the same form that needs to extract data from another table. I have a query that I intend to use to reference the data I need...but my question is what is the syntax to make this happen. Here is...

    DaChosenOne5 pointsBadges:
  • Hide print page that is blank in Access 2003

    I have a report that from a query displays multiple fields. In some cases a second page hold additional data. How do I suppress the second page when the main data section is blank?

    Richpax5 pointsBadges:
  • Report Page Header tied to Field in a Make Table in Access 2000

    In Microsoft Access: How do I write the control in (properties) of an unbounded box created in a report header to display the a month I query (Criteria -Enter: Month) which then converts to a Make Table?  When I run the query and am asked, "Enter: Month" and I type in "May", I want May to...

    Cappythequalityguy15 pointsBadges:
  • Assign Indicators to an Access Table

    I have a table in Microsoft Access that has duplicate customer numbers. I want to auto assign a number to the records,i.e. 1 thru 6. But reset to 1 each instance the customer # changes. Is there any easy way to do this?. Thanks

    Dash145 pointsBadges:
  • SQL Access Query

    I am using the book SQL for Microsoft Access. and the below statement is from the book and for some reasone I am getting a sytex error on the  word "Udate"     Why would that be?  CREATE TABLE Manufacture ( ManufactureID INTEGER CONSTRAINT ManfID PRIMARY KEY, ToyID INTEGER NOT NULL,...

    CompEng1,185 pointsBadges:
  • Access Query – Repeating fields

    I have a file of 70K names. Some are dups. I want to create a indicator in Access to flag when the name is repeated indicate 'Y' else 'N'. Any ideas on how to create a query to do this

    Dash145 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:
  • Make Table query Produces different result than same select query

    In MS Access what would cause a make table query to produces differnet results than same query as a select query

    Donjuanc5 pointsBadges:
  • Windows Sharepoint Servs 3.0 – Linking existing Access 2007 Database with new list.

    Is there any way I can link a pre-existing table/query in an Access 2007 database with a new Sharepoint list? At the moment, the only way I can find to do this is to copy the information from Access to Sharepoint, then import the copied data back to Access and link these two. I need to be able to...

    Domc1115 pointsBadges:
  • Problem MS Queries Refresh in excel file located on client network

    I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as "ODBC Microsoft Access Driver Login Failed" Disk or network error.

    Pavin5 pointsBadges:
  • Using WildCards in IIF Statement

    Hi, I have a query that uses a field on a form to filter what information gets displayed. This is simple I know but what I need it to do is display all records if I don't enter anything in the field on the form. I tried putting the following IIF statement in the Criteria:...

    RoadDust390 pointsBadges:
  • Sort Access Query From Variable

    I wanted to see if there was a way to sort an Access query based off a variable. I have a textbox on a form and I want to be able to type in a field name and then open one query and it's sorted by the field name I type in the text box. Any help would be greatly appreciated.

    RoadDust390 pointsBadges:
  • Export from Access to Excel shifts decimal position randomly

    I am exporting from MS Access '03 to MS Excel '03. I retrieve several columns formatted as Fixed width with 2 decimal places in a query and then export those results to Excel. Occasionally, some of the columns, but not all values in that column, will display with the decimal point shifted one...

    MBachman5 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