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 derfloh 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: *

  1. diverdown

    VBA Query

    Terry, Thanks for your help. I ended up doing a query for each hour in the day and then incorporating that into a report, kind of the long way around, but it worked. And actually, I meant sum, not count,. I would still be interested to know how to put the select statement into VBA with a for...
  2. diverdown

    VBA Query

    Sorry about the vagueness, but you guessed correctly. The table format is: ID Date Auto Walk Pub_trans Taxi Time_in Time_out 1 06/02/01 1 0 0 1 7:00 12:00 2 06/03/01 1 1 1 0 6:30...
  3. diverdown

    VBA Query

    I am not an access programmer or VBA, however I want to put this SQL statement into a query, and do not know how to set up the VBA part to run with a query. The initial query looks like this: Select Date, timein, timeout, count(auto), count(taxi), count(walker), count(public_trans, Hour(timein)...
  4. diverdown

    Access Query on Time field

    Doug, Please help, I am stuck with this vba stuff. I did a little SQL select but can't get access to recognize the for a =1 to 24.
  5. diverdown

    Access Query on Time field

    Thanks guys, but I am too new at this. I figured I would start off defining t as an integer to equal a)or start time, t + 1 as an integer to equal end time, but have no clue on how to open the table and insert into another table. I created another table with time in, time out and count, but am...
  6. diverdown

    Access Query on Time field

    Hopefully a simple question, but I am perplexed. I have an access database that is tracking the time in and time out of vehicles in a parking lot. What I need to do is figure out how many cars were on the lot between each hourly group(i.e 6 am to 7am, 7am to 8am, etc), I can't seem to figure...
  7. diverdown

    CDROM: can't get cdrom to read second cd on coftware install

    Hi, I am not a sys adm, however we lost our UNIx adm and I am trying to install Oracle on a UNIX workstation, and the cdrom will mount and run the install program, however, when the program asks for the second disk, I can eject the first disk, but the second disk can't be read. At first thought...

Part and Inventory Search

Back
Top