Search results for query: *

Ok - I'm almost there. I used a Make Table query that added an autonumber field and that worked great to get the records numbered. Then I used the following crosstab query: TRANSFORM First(IIf([FldName]="Cert",[Cert],IIf([FldName]="Desc",[Desc],IIf([FldName]="ExpDate",[ExpDate])))) AS DaVal...

Thank you dhookom. I'm sorry, I do not know how to post my data lined up. Here is a list of field names from the first post: EmplID|Lastname|Firstname|Status|Notes|Certification|Description|ExpirationDate|Instructor|Method The query pulls the data from 3 tables for 1 employee. The fields...

I have been working on the crosstab query for hours and can't get it to work. I am not totaling anything - simply wanting to get all the data in one record. So from my sample above I would want it to become...

I have a database that keeps up with certifications for various employees. I need to be able to choose a particular employee (no problem with that) and then I need that data to be exported into a PDF form. The form has the employee id, name, status, instructor and method at the top and then...

Thank you both! That worked. I actually got a different error when I tried it, but realized that I had Group By turned on and it does not work with that. I'm moving forward again - thanks to the two of you.

Regardless of whether I do it in the report of the query, I get the following error: The expression you entered has a function containing the wrong number of arguments.

Thank you for your help, Duane. I'm sorry I'm just now getting back to you. I only get to work on this database about twice a month. I understood everything you showed me except for the percentage under 18. I'm assuming that formula would be in the report (since it doesn't work on the query)...

Here is what the final report needs to look like: Surgeon:(Name) (Start date-end date) Surgery type ¦ No. of Procedures ¦ Avg Surgery time ¦ % Pediatric ¦ Avg length of stay And it’s the Avg surgery time & % Pediatric that I’m having trouble with. I have a surgery table that lists the...

Oh my goodness - I can't believe how easy that was!!! It worked like a charm, and luckily I decided to go to bed soon after the "make all forms" decision and woke up at 3:30 this morning to get a fresh start. Thank you Paul, for your help. It does frustrate me that I was not able to figure it...

Ok... I'm going to just create the other seven forms. I've read all about OpenArgs, and can't figure out how to send a formname rather than a fieldname. So, it's going to be faster (though not as "clean") to just create the forms. Thank you.

Wow, looks like I'm going to have to do some more searching - thank you both for your posts, but they are way over my head. I will search for OpenArgs and parsing and see where I get from there. Thank you.

I have a form that is used for creating a new office note and it needs to be accessed from 8 different forms. I do not want to create 8 different office note forms though. I have one form working and here is the code I'm using in the On Load event: Private Sub Form_Load()...

NEVERMIND!!! Sorry about this, but they have decided that they really want to pull the data up via county instead of city - so that means it's only one county at a time and it works fine. I would still love to know why this didn't work, but the "rush" is over and I'll just have to play with it...

Sorry I'm just now responding - have been out of the country. I tried changing the table and the query and it did not work that way either. Here's the SQL - keep in mind I had a query called CallLogCriteria and the table is Call Log Criteria. I bypassed the query and am using the table (which...

It's not stored that way right now - it's Athens "Athens" or "Malakoff" or "etc." Carthage "Carthage" or "Tyler" or "etc..." But I can look at changing it to that. Thank you

Update - if my search info changes (i.e. Athens only instead of "Athens" or "Malacoff" etc) it works. So I know it has something to do with the Or and the Quotes. For now, I'm going to list each city separately so they can start using it. If anyone has any ideas, please let me know. Thank you

That didn't work either.

Showing my ignorance here, but where would I put that?

Ok... I'm thinking that it has something to do with the quotation marks??? Since I'm able to do another query from the same form (to get the criteria) - and I tried a combo box instead of the options group and no change. Is there something you have to do when putting a form control in a query...

Let me see if I can explain this a little better. The form I'm using has an option group of 16 different cities. Each city has more than one city/county/etc option in it. (Example: Form shows Athens, and when you choose that option, it actually searches for "ATHENS" OR "MALAKOFF" OR "TRINIDAD"...