1
  • Where SQL statement is open ended

    Is it possible to have a where SQL statement that is open ended. I have notice that there are time that parameter box pops up with some the Access pass-through queries that I have.  Is it possible with SQL to be able to have a box pop up that would ask for a specific input to the...

    CompEng1,185 pointsBadges:
  • Finding Holes in Numerical Sequence

    I need help in identifying the missing numbers in a large query. The only problem is that some of the numbers may be alpha and numerical combined or not-they are mixed. Yet all the numbers are in the same column.  The query looks like this...

    CompEng1,185 pointsBadges:
  • Linking Carrier and Products in Access 2003

    I have a carrier table and a product table. The Carrier table i have CarrierID and Carrier Name. In the Product Table I have ProdID,Carrier, and Product name. What I want to accomplish on a form is when I select a carrier in a combo window and then select Product in another window , I want to only...

    Jasmine15 pointsBadges:
  • How can I ensure that the invoice data goes to the correct record on the subform datasheet?

    I use a form to hold the details of a client. The form has a subform [datasheet] which details each visit that the client makes. To do an invoice for the visit I have a pop-up form. I would like information from that pop-up form to be transferred to the datasheet subform. How can I ensure that the...

    Jhegarty5 pointsBadges:
  • MS Access Datasheet sorting using Runtime

    In Access 2000 runtime is it possible to enable some quick an easy sorting on a DataSheet view in a subform?  I am currently using a ComboBox to achive this, but it would be more intuitive for the users to just be able to click on the column heading like one would do in Windows Explorer..  Thanks!

    TJay85 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:
  • How to use SQL to filter columns in a spreadsheet.

    I have a query that is listed below. I need to develop a statement that would filter the month and the year as well as the Phase informaton in the access table.  __________________________________________________________________ Select INMSP300.M3OE# as "OENo", INMSP300.M3OEC as "ComprsOE",...

    CompEng1,185 pointsBadges:
  • Working with SQL: Extracting Data or Text within a Query, adding new column for extracted data

    I have created a passthrough query in access to draw information from an AS400 system. I have also created some tables in excel and copied and pasted them into access to link them to the AS 400 query via access. So as of now I have three files in one access passthrough query. The one file is "...

    CompEng1,185 pointsBadges:
  • Access & iSeries AS400 Tbl and Query Issues Error Code 5001

    I am in Access and I have (A) a passthrough queries=(INMSP300) and (B) table queries=(dbo_ECC_APP.OEM),I want to join. In the dbo_ECC_APP.OEM there are number identifiers that have no associate number were in INMSP300 there are both and they are associated. So I need to have all the number in the...

    CompEng1,185 pointsBadges:
  • Access – Bound sub form trying to set the value of an unbound field

    I have a bound sub form with a Datasheet view.. One of the fields on the form I want to be unbound, but still display the value of a field for row displayed. How do I show the value.

    TJay85 pointsBadges:
1

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