Include / add dates in a query

H

hermie

I have a table named absent which shows the dates when a student is absent
(fields: IDabs,name, ss, and date)

From this table I have crosstab query that list all the days of a student
absent during a certain period. Now I like to create a query or report that
also include the days when a student is present exclusive the weekend.



Is this possible?



Herman
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crosstab query to include fields with Null value 2
Template with fields and premade texts.. 0
Append Crosstab Query to Existing Table 0
Create a Control in a form that can store a cumulative count 2
Query to display the difference of period for an employee. 1
Word docs emailed to me are opening blank (greyed screen) in Print Mode 0
Dates In Excel 5
string crosstab query 1

Top