Search results

Does anyone have a query that will put time in hour blocks for a 24 hour period? Example: 13:45 would be put in "13:00 x 13:59" Example: 14:15 would be put in "14:00 x 14:59" I think it would look something like this but there might be an easier way: Time Groups: IIf([Time] Between 13:00 And...

I have 2 tables. 1 is a name table. The other is an AKA table with multiple names. I joined these 2 tables with an auto number. The created a query for both these tables joiing the numbers together. When I run it I get no results. If I take the AKA table out of the query it works. I can I join...