Search results for query: *

ok - tks

Hi VRoscioli To answer your question, yes I want to group different values for the org. For ex. Q488 is the head org and they have 8 students and within that org is Q4884 which has 2 students. Instead of producing line by line of each org like I have above, I was looking just to be able to...

Tks for the replies - I will try those.

Hello, If I have a query which produced the following: Org: Status: Count of Status: Q488 Student 8 Q4883 New Hire 10 Q4884 Student 2 Q4886 New Hire 5 The Org field and Status field are Group By in the total line and used...

ok - tks

I did not say DAP sounded complicated. The process of getting it to update the table is what I am trying to do. I already have the DAP generated and I would upload that page to the server. What I want to figure out is how to get the input data to go into the Access table. And when you...

Doing the splitter and putting the table database on the server, and also putting the DAP on the server - wouldn't they be able to assess the DAP via a web page and the info entered would go the the table database?

We thought about a shared drive but it would be a lot to keep track of permissions since dealing with about 300 people. That's why I was looking to having it on a web page on the INTRAnet where people can just access and submit their entry. When you say splitting the database, you mean parts...

Tks - this seems complicated. If I should use it on the intranet, would it be the same procedures? Do you have to use DAP using IE? Can Netscape be used?

ok - that worked - tks. I was able to input. Is there a way to have the DAP open in add mode? I do not want to have all the other records available. Only want to have a blank form displayed for input entry only which the data will go into the database. For this to work on the web, would I...

Sorry, but what is the DAP. How do I go about doing that? tks

I generated a data access page but when viewed in the browser, I cannot type in or edit any of the fields. Is there something else I need to do to the page? What I want to do is have a page on the Internet which I generated the page from a table to have people to be able to input data on the...

ok - I see. I guess I was thinking when an item is closed, I wanted it not to appear in the table. But creating a query for the active items would do the trick. tks for enlighten me.

I have a table with a field called Status of Action which has the choices to choose Active, Completed, Closed. Once an item is closed, how do I go about placing this entry in a closed table. Do I have to set up another table named Closed. How would I write the code to put an entry once...

When I do the query, it displays the Overdue column along with the days overdue. But when I want to review in the report format, it just displays the Overdue column without displaying the days overdue.

Another question - when I display in the report format, the overdue contents does not display. Only the heading Overdue. Can you display the the contents of the Overdue field in the report? tks

That's cool - tks PH.

When I entered the query below - I received the error - "You may have entered an invalid identifier or typed parentheses following the null constant criteria." The string: Overdue: IIf([Due Date]<Date(), Int(Date()-[Due Date]) & ' days past due', '') I do type this string for the criteria in...

When I entered the mentioned query - I received the error - You may have entered an invalid identifier or typed parentheses following the null constant criteria. I do type this string for the criteria in the query design. pls verify. tks

I had asked this question previously and was told to use the DateDiff() function. I have an action database with a field Due Dates. I named another field Overdue which is currently blank with I want to use for the query results. I want to figure out once a due date is past, have the results...