Search results for query: *

I have tried looking through MS help and MS help forums and could not find and explaination of the difference between these two functions. If you go to tools --> options -->calculation in excel 2000 or 2003. you have these options to calculate a workbook. I would like to know the difference...

I am creating a database in which I have many options in a listbox that I can select. What I would like to do is to somehow populate a textbox with the selected items from the listbox separated by a comma. This sounds like something easy enough to me, but I have been away from access for a bit...

I am an intern at my company and I was asked to research about a particular Excel spreadsheet that we use. It is a tool that we use that is in the form of a spreadsheet that is over 40 meg in size. It runs thousands of calculations, and lasts for 10 minutes when recalculating. My question is: Is...

I have a simple database at work on the server that I use for keeping track of survey information. This database is used by other users on occassion to update the data. There are over 500 records in this database and I have a need to use the built in Find or Find/Replace tool. When I use the...

Wow, thanks. Just what I was looking for. Just need to tweak it a little and I'll be set.

I created 2 crosstab queries in Access. Now I want to open Excel and link to them so that I can perform a calculation on them to get a crosstab of averages from the two queries. The problem is that I can link normal Excel queries, but the ones I created that were crosstabs do not show up for me...

Thanks a ton for being patient with me. I will try this on Monday when I go back to work. I wish I had more experience with SQL.

Query in SQL view

I forgot to tell of my table(s). I am drawing Data from 6 tables Employee joined to Service by EMPID Patient joined to ADMIT by PATIENTID Program joined to Service by PROGRAMID Admit joined to Service by ADMITID Episode joined to Service by PATIENTID I know that there is probably some DB...

The visit is always 1 I think, but I summed to get the totals. Sorry about not putting code this was my first post to these forums. I'm just an intern :P Here is my Group By SQL Code (this is what Access wrote because I am not strong with SQL) GROUP BY [EMPLOYEE]![LASTNAME] & ", &quot...

I have a problem in a query where I have Nurse names, Patient Names, # of visits, Year and Month. I am not getting the right totals for each month, I am getting the overall total for all months. Example below What I get Nurse Patient Visit Year Month Jane Doe John Doe 12 2003 5...

All that I have to use for Reporting at my company that I intern at is Oracle Discoverer 4.1. I have found that this program seems to be very limited in that I cannot suppress details as I have in my college classes using in Crystal Reports. The particular question that I have is... Is there a...