Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: corrado
  • Content: Threads
  • Order by date
  1. corrado

    Between statement ?

    I have a query that is based on a table and have a column of data that shows completion dates of (11/15/02, 11/02/02,11/17/02, etc...) I want to prompt the user to enter in a start date and an end date and want to show any data that is included in this start/end date. I have the following SQL...
  2. corrado

    Form question:

    I have a form and would like to have a drop down box appear that holds a list of values (names). I have additional columns in the form that were taken from a table which holds the (names) address, age, phone number, car, etc.. Upon selecting a name, I would like the remaining boxs to have the...
  3. corrado

    Saving .JPG in ME but turns into VBscript

    I am saving .jpg files to my desktop and I can open them fine for about a day, but when I go back the next day it shows that it is now a VBscript and I cannot open it. I had a bunch of .jpg files in 'my pictures' folder and I cannot access any of them. Is there a way to stop this madness. I...
  4. corrado

    More issues with Dates

    I had sent out a message a few days ago and had responses, however this is still not bringing back correct data: I'm only concerned with the where clause. The [ACCOUNT Query].MAJCOM works fine. Issue: want to display only dates that are older than 1 year from todays date. (for Account.Letter...
  5. corrado

    Possible use of IIF statement for dates

    I am trying to display (in Query) a letter date that will read the column value and minus one year from that date (that date i.e. meaning today's current date). Value(s)of Account.Letter 10 OCT 00 15 FEB 99 25 MAR 00 15 JUN 00 27 SEPT 00 01 MAR 01 I want to display any date that is greater...

Part and Inventory Search

Back
Top