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

Gentleman I got it. I created seperate query with your help than added that query the original. Works Thanks

When I Jion the two tables with "include ALL records from NameTable and only those in AKA table where the joined fields are equal" I get The SQL statement could not be executed because it contains ambiguous outer joins. To force one of the joins to be performed first, create a separate query...

Gary, Thanks for the help. I know my post is a little confusing but I will try to add some clarity. I have the 2 tables (NameTbl and AKA table). Their joined in a query by the auto number. I created a form with the name table.Than I added a sub form (aka tabel) to accept multiple AKAs to the...

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