Recent content by jdwm2310

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