Search results for query: *

I have a query that will tally up employees with medical elections. I would like the query if possible to calculate the totals. Can this be done??? If so, please HELP! Thanks.

Please help...i am trying to create an outer join query. I have two queries one with a criteria to include spouse information and the other without spouse information. How can I join these separate query to create one query?

No answer yet. I would appreciate if someone could lend me a hand...thanks

Hi created a database which is shared by 5 users. It was working perfectly however something went wrong. The users create tickets however I am not able to view their tickets. It seems that the users are working on an individual database instead of a sharable database. It seems that I lose my...

Hi, I currently send my forms via Lotus Notes. I would like to change the font color of the body text in the email. I want to distinct some text in the message. How could go about doing that? Please review my code, thanks: SendNotesMail "Ticket number " & TicketID & " has...

Bigsteve42, Let me explain what I am doing. I have a form call frmHelpDesk. the users use this form to enter tickets. If they click on Route to, the ticket status is "Open". If the user would like to see that "Open" ticket. They go to the Main Menu. In the Main Menu...

Hi Guys, I have a form called frmOpenTickets, a user encounter this form from a menu list. This form stores all the tickets that have a ticketstatus of "Open". The user would open this form if he/she decides to close the ticket. On form I added a checkbox stating that "Please...

here is the sql: SELECT HelpDesk.CallerName, HelpDesk.CostCenter, BusinessUnit([CostCenter]) AS [Business Unit], HelpDesk.[Date Call], HelpDesk.Area, HelpDesk.UserName, HelpDesk.[Date Closed], HelpDesk.[Route To], HelpDesk.[Call Source], HelpDesk.TicketStatus FROM HelpDesk GROUP BY...

Hello, Is it possible to have more than one parameter in a query? If so, the query that I am working with will not generate the result for two criteria. When I remove one criteria the query will work by reporting the parameters result.

Ok...I have a main table called tblHelpdesk..here is where the users enter information (i.e.; CostCenter) I want to create a query using the tblHelpDesk and link it with the tblBusinessUnit and tblCostCenter. In this query I want to have a criteria that states "Enter Business Unit&quot...

Hi, I would like to create a query that looks up the data for a specific business unit. I have three tables: tblCostCenter - has the costcenter # tblBusinessUnit - has the name of the businessunit per costcenter tblHelpDesk - is the form that everyone will use. The user will enter the...

zerosandones, On the second table, tblCostCenter, the BusinessUnitID is a number, right? I entered the SQL in the RowSource but when I click to view datasheet there is nothing in the combobox. I entered the BusinessUnitName in tblBusinessUnit. I did everything you wrote: I created the two...

medic133, Thanks for you suggestion. I added some If and then statement to check the form before closing. It works great. Thanks again!!!![thumbsup]

Ok on this everything you said...now how can I get the users to enter the business unit name and see all the records for that particular unit?

Well when I removed the Criteria. It works but I want my users to specify a business unit. How could i go about doing that??

zerosandones, I removed the criteria and it works. How could i insert a parameter that will allow my users to enter the business unit of their choice?

zerosandones, Your comments were well put, I appreciate your help and suggestions. Now I created a table with CostCenter and BusinessUnit. How would I go apply it to my query with a Dlookup function..I want the user to enter the Business Unit. And allow the query to pull up all the...

Hi, My query was working but now it doesn't work. I get an error of "Undefined Business Unit in expression" My expression is Field: Business Unit: BusinessUnit([CostCenter]) Table: Blank Total: Expression Sort: Blank Show: Blank Critiera: [Enter Business Unit] I created a module...

I have a query that works great in my other database however I copied it into my current database and it gives me an error stating that "the expression is typed incorrectly, or is it too complex to be evaluated." Here is my expression: BusinessUnit is a module I created...

Ok something is not working right probably b/c I am not giving you enough information... I have a form which gets it field from HelpDesk, CostCenter is from this table. When the user goes to create a ticket, and adds the caller name the costcenter is autmatically filled which is obtained from...