Search results for 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...

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...

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)...

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.

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...

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...

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...