Search results

Thanks Pat, Side by side, the rows of the Datein and Dateout fields (columns) are not an equal match in terms of either date (now converted to week numbers) or number of rows for either field. A very abbreviated example is as follows: Datein Dateout 28 28...

I have Datein and Dateout fields with many rows of dates beneath each. I used DatePart in a query to convert each date to a week number; but now need to count, and total, how many times each week number occurs under each field. I'm sure this can be done easily, but I'm new to expressions...