Search results

I would like to make a database that is used to sign in and out so the amnount of tim spent in a lab can be tracked. I had some good beginnings but am confused about how to make sure someone has signed in before they sign out. Thanks

I would like to make a database that is used to sign in and out so the amnount of tim spent in a lab can be tracked. I had some good beginnings but am confused about how to make sure someone has signed in before they sign out. Thanks

I have a main forms and 2 subforms. When I add data to more than one I get an error that sayd eomeone else has tried to update the same record and I have to choose update or delete changes. How can I hae them so I can go into all 3 forms and make changes for each record. Right now I have to...

Subform or just linked I see your piccture (thanks), but I do not actually have the subform showing in the main form. I use a command button to open and close each. I must have it partially right because sometimes it goes to the current record ans sometimes it does not. I had a large amount of...

I have one main form with 2 other forms off it. I can move back and forth with command buttons but noticed that when I go to the subform I a not on the same record. I saw posts about Master/child links but I cannot find that option on the data tab on my form properties. I am using Office XP...

I am using a sign-in program that was written by another person. It is just an Access database that tracts time and what class people sign in for. I need to add a sign-out option for one class. Any ideas would really be helpful. I am not sure where to start. Thanks

Thank you, that does work. Now I want to count how many of each. I am able to get a count of all levels but where it is a 0 or blank I want to also have a count. I have tried, Is Null and <10 (because my lowest level is 10) and it does not work. I would appreciate any suggestions. Thanks

I have 2 col and one or both may have date in it. If there is data in B I want to use that but if it is empty I will use A. I have a statement that is doing what I want for B but if B is Null and I want A all I get is Error#. What I have to do is count how many of each level and if they have a...

Okay thanks I will look it up. Ashamed to say I do not know how. Tricia

Thanks for the info. I did run one query to test and then ran it individually on each table too and the figures were fine. First time around I was off a few but went back and added SS# which is my primary key and it seemed to fix it. I had left it out on purpose incase 2 sites were working...

Thank you. I have my union query and it works fine with my renamed fields. Now to run all my queries on this what do I do? Is there a way to save the result to a table? I can copy the queries and make name changes if I have to. I have select queries and then crosstabs running off them...

Union Query prob cont. I have had a little luck with the Union query. But for some reason if I try to use my field names in the statement "Race AS Race" it gives an error about circ. ref's. If I let it do it's own thing it uses Expr1, Expr2 etc. as my col headings and that will not work with my...

I appreciate the replies. I will go see what I can do. I had thought of making them all one query but I guess I do it worng. There are several questions that are answered in a form and then I do a count on each. Ex. one is Labor Status and there are 3 choices. If I use that in the first col of...

Can you make a report that pulls data from more than one query?

I have a database that I have given to 5 different sites and now when I get a copy of each file back I want to combine all the totals and run 6 different queries on it. I do not want to append because I still need each separate also. I started a UNION query and it seemed to be working until one...

Sorry but I have one more question. If I make a query to put them together how do I run my current queries on the result. Does it create a new table? T

Thanks I will give this a try on Monday. No they are not all networked. I have emailed them to each person. I played with the idea of putting it on our server and letting everyone enter into one DB but am so new at this it would have been too hard. Thanks Tricia

I have created a database to keep track of students inour programs. There are 6 complicated queries I spent a long time making. I have given this to our 4 other sites and they have all entered their data. When I get all the files together is there anyway I can run my queries and reports and get...

I thank you for the reply to my previous post. I have one more. I will put up what I did: NumCompLevColD: IIf([Posttest Score]>=[Pre-Level] And [Withdrawal Date] Is Null Or [Exit Date] Is Not Null And [Posttest Score]>=[Pre-Level],"Completed Level") Okay I want this col to put the word...

Thanks much.