• datamining SQL with access

    I have been asked by the sales department to datamine our SQL database and pull the names and e-mails of all our guests for the last few years for a contact list. I am new to SQL but have worked with access in the past. Using access, how do I set things up so that access will see the database...

    Daiishi0 pointsBadges:
  • Report -Conditional Format with multiple conditions: Access 2007

    I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()-...

    Nichalos825 pointsBadges:
  • Microsoft Access and Oracle

    Can tables created in Access or Excel be imported into Oracle?

    Micheline foxxe10 pointsBadges:
  • ,temporary files, on win02/03 servers in access(.ldb files) and excel are not deleting when applications are closed

    can someone provide a possible solution

    Wildbull5 pointsBadges:
  • Convert OO Base to MSA

    Is there a way to convert an existing Open Office Base database to MS Access?

    Naomih15 pointsBadges:
  • MS Access-Query

    I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

    FranktheMan15 pointsBadges:
  • Using Access Data Bases on My Web Site

    I have a library of information that I maintian on my web site. Because it is getting large, it is difficult for a reader to find what is there. Is there a good example of an MS Access Data Base Application that allows different sorts of the information? For instance: By title, By Publication, By...

    Strategist15 pointsBadges:
  • Microsoft Access – Find and Replace Issue

    In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

    Santino35 pointsBadges:
  • SQL 2000 to Yukon Migration

    We have 4-5 applications on the front end of a portal. On the backend we have mapped these applications to SQL server 2000 Databases. Now, we are planning to migrate on the backend databases to Yukon and map it to the application on the front end. My question: Is it possible to use Yukon for one of...

    Kilaru0 pointsBadges:
  • Dynamic updates to a DNS Server

    What Windows Operating Systems support dynamic updates to a DNS Server? Which service needs to be running on the clients?

    1111100 pointsBadges:
  • What is NAT port forwarding?

    Describe in brief how you would set up port forwarding on a NAT router to allow a PC on the LAN to publish its web to the internet.

    1111100 pointsBadges:
  • How supply password in VBA during CompactOnClose for back-end password-protected db?

    Access 2000: Goal: to open and close a password-protected public access db (which compacts on close) and hide the "Password Required" prompt on open and on close. Purpose: Provide public access to Main.mde and protect Main.mde from remote connections, i.e, import & link. I have password protected...

    Dlc9ball20 pointsBadges:
  • Months query in Microsoft Access 2000

    On the basis of my query i have built a totals query as follows: SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate FROM qryMargin GROUP BY qryMargin.invoicedate; I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange...

    Peljo20 pointsBadges:
  • MS Access Date Time

    I have a date time filed in MS Access a database and woudl like to be able seperate in a query but so they keep the format settings. ie the date is a date and the time is still a time

    Han848490 pointsBadges:
  • Exporting MS Access data to Oracle

    Hi, I am exporting MS Access tables to Oracle using ODBC. I face MS Access 'Overflow' error for the tables which has date/time fields and has values in the format MM/DD/YYY. The error happens for only some of the data, for example 10/15/101. Please provide suggestions for how to solve this error....

    M15 pointsBadges:
  • How to read/write Access 2003 mdb records on server via INTERNET connection

    It seems that I'm a rather thick-headed nubee . . . Here's the scenario - Running SBS 2003 on T105 box. Running Access 2003 on client under XP Pro. mdb has been published to wwroot with FP 2003 with full control permissions set on the folder containing mdb. All works when opening mdb locally. When...

    RalphW25 pointsBadges:
  • Microsoft Office & AS/400 Database

    I am trying to bring data into Microsoft Access 2007 using ODBC. If a database has multiple members, how do you define/select the correct member in the ODBC definition? I have no problem getting the library list, and can see the files list but unable to select the member.

    Lshipley515 pointsBadges:
  • IIF clause

    Can you help me build the right IIf field in the query with the following conditions : The field DDU consissts of : DDU :[exworks]*2+0,4+0,01 To the above expression i must also add 0,001 if size = 205, etc according to the following table : 205 0.001 60 0.001 20 0.009 1 1.32 4 0,32 0,5 1,67...

    Peljo20 pointsBadges:
  • MS Access – Count of parent table items in a report

    I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the...

    LegacyDave5 pointsBadges:
  • Access 2007 refrence look up

    Ok this question might sound kind of elementary but i just seem to be missing something. I have a drop down box, within that combo box i want to display choices which consist of 3 cap letters then a "-" Then what the letters stand for. when i choose a selection from the combo box i want it to...

    IT-Guy1509210 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