Search results

I have created an appointment scheduling database. I have had complaints on the program "just dropping appointments." I figured it was user error...and it was, but I'm trying to find a way now how to use their Novell login to attach what user either deleted the appointment or made some change...

Thanks for responding....I tried the me.requery, but still not the results I am looking for. What I'm looking for is a fix if two people are viewing the same form from two different locations and one user makes an update, I would like for the screen on the other users form to be updated as...

Never mind...this has been settled on just pulling all the updates, not just the most recent four. ________ EXPERT INSURANCE

OK, now I'm being requested instead of returning only the most current updates (MAX) the would like the last four. Is there a way I can do something like....MAX + 4? Thinking that it would return the 4 most current updates? Thanks in advance, Kacy ________ BUY VAPORIZERS

I have a multiuser database that is used to schedule appointments. Once in the main Form, the users select a facility from a drop down box and the suborm shows dates and times that are already filled. Their concern is if they are all in that main Form and somebody schedules an appointment, the...

Just wondering where at on the Format did you set it to "0"? Thanks, Kacy ________ LovelyWendie99

ok...one more question. On the report you have to different headers....1.) Page Header and 2.) autoProjectKey Header. How do you create the two header. All that I am seeing is the report header and the page header. Thanks again, Kacy ________ Lovely Wendie

This is great! You have helped me out so much and have taught me a thing or two. Still a little confused on the " What does using this indirect route allow you to accomplish that you couldn't by just building your query on the actual values?" , but oh well. I've got what I was really looking...

First of all, thanks for responding... you've been a BIG help!! I wasn't able to convert the db that you sent. I use '97. Is there any way you would convert this to '97 so I can view it? I'm going to attempt to answer some of your questions.... Please let me know if you have any insight on...

I have attached a sample database....Open the Report and you will see that there is a new report being created each time for the same project, the only thing different is the Weekly Update field. I would like one report per project, but lists all of the Weekly Update fields one after the other...

Let me be more specific because I can not get it to do what I want it to by grouping. Here's my query results..... PROJ_ID---PROJ_TITLE---UPDATE_DATE---WEEKLY UPDATE -----1-------TEST 1---------3/31/03---------UPDATE FOR 3/31 -----2-------TEST 2---------3/31/03---------UPDATE FOR 3/31...

I am doing a Project Tracking database so users can input where they are on specific projects. I have a seperate table that contains Weekly Updates. In this table there is a Proj_ID, Date and Weekly Update fields. I have a query that links my Projects table with the Weekly Update table. On...

Thanks a lot!! You have been a big help.... Kacy ________ Lovely Wendie

jfgambit, I didn't see the attachment on the previous post. I tried it and it works great. Thanks a ton. Before I saw the attachment I was working on the following to the query that I had. Out of curiousity....does this work the same? Query 1: SELECT PROJ_ID, Max(UPDATE_DATE) AS...

First of all, I apologize for emailing you directly in response to the nested queries. Here's the two queries I have created. They are linked on PROJ_ID so it's including all of them as where I just want the most recent update. Note: I should say that PROJ_ID is not unique. I've created a...

I have created the two queries. It's still not returning back in the right order. For PROJ_ID 87 it's returning the UPDATE_DATE info for 3/24/2003 instead of the 3/25/2003 info for that PROJ_ID. Any idea,.....sorry, Kacy ________ Weed

Thanks, I will try that. I have another question for you. If I make this two queries can I have the second of the two as my recordsource for my form. I guess what I'm asking if I use the second query for my recordsource will it query the first one automatically? Thanks, Kacy ________ Extreme q

Here I have tried a nested query, but am having a hard time. I've never done one before. Select A.PROJ_ID, Max(A.UPDATE_DATE) AS MaxOfUPDATE_DATE FROM tbl_Weekly_Update AS A GROUP BY A.PROJ_ID (Select B.PROJ_ID, B.MaxUPDATE_DATE, A.WEEKLY_UPDATE From Query1 as B Inner Join...

I grabbed just the table and query that I'm testing with...thanks. Kacy ________ Public Vids

Ok, here is the latest of queries that I've tried.... SELECT A.PROJ_ID, Max(A.UPDATE_DATE) AS MaxOfUPDATE_DATE, Last(A.WKLY_UPDATE) AS LastOfWKLY_UPDATE FROM tbl_Weekly_Update AS A GROUP BY A.PROJ_ID ORDER BY Max(A.UPDATE_DATE) DESC; When I run this query it's not giving me the correct...