Search results

Thats perfect, I do not need records back, another query will do that. Do you have an example on how to set up the query?

Is there a way to run a Stored Procedure in SQL from Access? I have a rather long query that takes too long to run locally and a stored procedure would work for this, but I cannot figure out how to run it. I would like it to run when I open the Access db. The project I'm working on is using a...

It will only be accessed by 1 user at a time. But that user could be at a different PC every time they access it. If I could run it locally I'd be fine. The issue is that my form has about 30 queries on it and it refreshes after every selection, there is about a 7 second lag on the network...

I have a db on a network drive and the performance is terrible, it runs fine on my local machine. How can I make it run better? The db is only 2 megs so I figured it would be ok, but since my forms have numerous queries within them, performance stinks.

OK, I figured out how to append the rows, I put all of the appends in a macro. Is there any way to suppress the message "You are about to append one row..." so I do not have to click ok 34 times?

The data is linked from a SQL db. I run a daily query to get my (unnormalized) data. How would I use append queries? I'm not sure what you are thinking?

The problem is that I'm getting the data from another system, daily. There is no way to do it manually or receive it in a different manner. I'm not sure what else I can do. I need to query the data each day to provide a list of employees for that particular day.

I am working on a scheduling application. The data is being passed to me in the follwoing format: Day Room1 Room2 Room3 Room4 Room5 Room6 Etc... 1/1/07 Jon Bill Ray Julie Tom Paul 1/2/07 Bill Ray Jon...

Does anyone have any ideas on how to set up a daily scheduler? The only restriction is that there are 20 positions to fill, but the list of possible employees is 50, and as you select employees from a list they must get depleted from that list so that you cannot possible use them twice. The...

Ok, I took it out of Access and ran it from SQL (Toad) and it ran fine. In fact it's incredible that there was a simple solution to what I thought was a complex problem. Thanks! Now I have to figure out how to get the difference in the temps, it will be tough since the values are in different...

I just indexed the field, same result, the PC hangs. I am only querying 810 records, I'm using a sample of the real Data (300,000 records) Originally I thought the data set was too large, but it hangs with only 810 records. The smaller I make the data set, the quicker it hangs. I even renamed...

This query always causes my PC to hang, Do you know what is wrong with it?

Thanks Guys!! I'll give these a try today and see what I can come up with... Dave

Ok, I sort of understand, but that gives me the top 10 for the enitre table. I need the top 10 for each person in the table. Each person may have 100 to 1000 readings....

I have patients with temperature readings every minute. Some last an hour some last multiple hours, some last days. There could be 100, 500, or thousands of values. I need to find the 10th value and 10 values before the end of the value list. So if someone had 60 temperature readings, I need...

Anyone else have an idea on how to do this?

I can, I'll post it tonight. Thanks for your help

Yep, your query is getting the same result as I mine. Either all or none. There has to be a way to do this, I'll keep thinking.....

It does run without error but returns "0" for all of the values, it does not recognize any of the fields chosen the the nested select CRNA_CC Expr1 Smith-9725 0 Adams-6270 0 Wilson-2234 0 Bender-2154 0 etc.... Is there a better way, or a way that works? It sounds simple, but I've been...

The textboxes are bound to a table. The source of list box is a separate table. here is what I tried, but it does not work: SELECT List_CRNA1.CRNA_CC, not Exists (select unscheduled_pto_1, unscheduled_pto_2, unscheduled_pto_3, unscheduled_pto_4, unscheduled_pto_5, unscheduled_pto_6 from...