Search results

yup that worked, thanks for your time

nope they have different dates per user per test, so all the questions to one test have the same time stamp. I think i have a way to do it, do a group by user name and min on the timestamp then to a join on the main table.

I have a database that has the testing scores of users but some users did the test more then once when they were only suppose to do it only once, for every test there is 40 records generated with a time stamp. I want to pull off the first 40 records for each user so i can get their first test...

hmm ok thanks for the infos

I have an access database frontend with a SQL Server backend, the backend is located in Kansas City and the frontend is on a users desktop in Cali. It takes forever for the server to run some simple querys, is there a better way to do this so it doesnt take so long? What i think the problem...

hmm ok thank you for your help

thats the thing I am using a standard SQL login to import these tables so from the sever login everyone looks the same. Does that make sense?

I currently have a query in an access database that filters the records in a Sql Linked table for their user ID. So basically i use Environ("UserName") to filter for a field that contains their user name. I want to secure this and put it on the SQL Server so there is no way anyone can see any...

Ya thats pretty much what i have right now but it is all stored in Access, is there anyway to do this on the SQL Server. This is probably the wrong forum for this kind of question.

Thank you for the reply. Is there a sql server side solution i could put in place to where a user can only edit entries they have made (i log their user id in the record when they create it) into the database but have the ability to read everything? It sounds like i could do this with a query...

I want to secure my database so no one can mess with it or see anything other then what i give them. I have tables imported from a sql server and want to be able to make it so they wont be able to see those, whats the best way to do this?

hmm ok, i was just using a Form datasheet view. Thanks

Does anyone know how to make the labels in datasheet view vertically aligned?

I think i found my own solution :D http://www.techonthenet.com/access/functions/index_alpha.php

I am trying to build a dashboard kind of database. I have a text box on a form and a query that is the totals of how many calls was done per day. I want to make that text box equal the total number of calls that are in that query, how is this done?

ya thats what i had to do, anything else i can do?

before i pull out any more of my hair, I am making a pie chart and the "Best Fit" function in access charts for form flat out doesnt work. Does anyone have any suggestions on how to get these labels from bunching up?

got it, thanks guys

I just got done migrating the tables in my database to a SQL server, I went in and deleted the extra table that was created with the migration manager so all the data in my database is on a SQL Server, For some reason the size of the database is still the same. Why is that? I even when in and...

I figured it out, thanks for the help SELECT Min(tblPSC.Date) AS MinOfDate, tblPSC.OrderNum FROM tblPSC GROUP BY tblPSC.OrderNum; http://office.microsoft.com/en-us/access/HA010345581033.aspx