Recent content by lilyaqha

I don't think i'm doing this correctly. What is expression, domain and criteria? Sorry i've been busy with other things at work. I'll try again on Monday if that is ok. Thanks for your help.

Post number ten!

I would like to copy and paste what i've done, because it isn't working. I only have 9 posts though.

Not quite yet! Someday though! So, I uploaded the tables Today/Yesterday. Now, what do I do? Create a query hit * and put the DCount formula in?

It does. The final queries have all the data I need for the report I send. Or, I can upload again as tables for Report - today Report - yesterday to compare.

Ok, so each day i'm sent an excel document of all students in all classes. I have to sort to get the particular course I need, then add addresses from another excel report i'm sent. There is a 3rd report i'm sent that has home campus and delivery campus, which I need to sort as well. I need...

Some explanation..I pull the same report, daily. The records are all students who are enrolled in a particular course. Everyday there are more students enrolled in this course. I pull the group of students, sort for the students in the particular course, then send out the report. What I was...

Can I attach as an attachment?

can I post a picture of what i'm working with here? I have the 2 tables. Created the queries, but the date thing threw me, because I don't have dates. The count would be of DSI number. Oh I can't, I need 7 more posts to be able to post the pic. BRB.

I'm very basic with querying etc. How should I set up the query? I saw the Dcount function but wasn't sure how to use.

Can I create a query that compares Today's report with Yesterday's report, and generates a number based on how many more "new" records are on Today's report? I'm tired of having to open both, then compare. Thank you! :D