Recent content by Wulf13

I'm in the military and am trying to build a database that allows me to keep track of what post my troops where on a what day of that month and if need be print a report for a specific day listing all posts for that day. Currently we use 2 excel spreadsheets that are linked and do this for us...

No problem. I'm sorry to hear that, I hope she is well. Take care.

pbaldy, where you able to figure anything out?

My bad, I forgot. SELECT Query1.name, Query1.studentNum, className.className FROM Query1 LEFT JOIN className ON Query1.className = className.className GROUP BY Query1.name, Query1.studentNum, className.className HAVING (((className.className)<>"COMSEC" Or (className.className) Is Null));

Ok, so I tried to redo the unmatched query and I made it harder than it needed to be I think. My brain is a little fried from a 5k run this morning. Anyway, I've re-attached the DB with the unmatched query. Thank you for your patience.

Oops, that was my bad. After receiving your first post, I went back and tried to put both into one. I deleted the unmatched query that I had. I can repost with that query if you'd like.

Ok...here is a 2k version.

Sample Here is a slimmed down version.

I thought about a subreport however the names would be divided into two sections whereas I want one. I'm not quiet familiar with a union query but could try if need be. I'd prefer to get all the info with one query. Here is the structure: tblOne: name studentNum (P/k) organization tblTwo...

My DB tracks courses taken by people. Most of these have an expiration date. I can make a query to show me who is overdue on class "x", "y" and I can make a query to show me who hasn't taken "x", "y". Is there a way I can combine the two queries into one report?

Has anybody figured this syntax for this yet? I too am having the same problem.

Its close but that example covers a ordered range. I want it to be dynamic. Instead of a range I would like to be able to pick out just specific days in within in the range. I.E...instead of Sun thru Sat results, I'd like any combination of days such as Mon, Wed, Thur or Tues, Wed, Fri.

I have a query that displays all records. I need it to limit based on multiple criteria in a single field. I.E... instead of all employees from every section, I just want it to display employees from section A, C, D, F one time and next time maybe go with section B, C, D. For some reason the...

OK so I got creative and here is what I came up with: ItemType: IIf(InStr(1,[itemNumber],"-")>0,Left([itemNumber],InStr(1,[itemNumber],"-")-1),[itemNumber]) This looks for the hyphen and if not found it just displays the itemNumber as a whole, and if the hyphen is found it strips of the...

Let the beatings commence... ...I shall start at their head. Unfortunately, you fine folks are spot on. It's not always 2 characters before the hypen. Is it possible to debug a Query on error??