Search results

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

Here is the statement in my query: ItemType: Left([itemNumber],InStr(1,[itemNumber],"-")-1) It takes the following string "M4-1234567" and displays everything before the hyphen. Yet when someone doesn't type in a hyphen it gives me an error. This prevents me from generating my report. How can...

I'd like to create a query that shows me what employees haven't had a certain training (i.e. Bob hasn't had heavy machinery training). I've played with the unmatched records wizard and it just seems to not work out no matter how I connect them. I think the only two tables I need be concerned...

First of all, my apologies to Miss Hartman, I've made an erroneous assumption. I've corrected my previous post. Second of all, Doc Man, my first impression of your post is it seems rather daunting and confusing. I shall have to print it out and take it with me to read while I'm at lunch to get...

Wow...don't I feel stupid Paul-thank you for pointing me in the right direction. I should have looked at this topic sooner, I've always ingored this 'multi-select list box' that I hear about. Yet now I find it is pretty much what I need. I've looked at several examples...Miss Hartman's being...

I have a DB I'm using to track training for assigned people. Right now the training gets put in the DB at the end of the day by going through each persons record and adding the training that they did for the day. As you can see when training 30+ people a day, putting this in the system can take...