Search results

I'll answer all your PowerPoint questions if you answer my Access ones! PowerPoint is like a puzzle too. Knowing what you want to do, then figuring out how to do it. WIth Access, I know there are puzzle pieces, but they are are jumbled, and I don't know how they fit together.

It's that properly normalized thing that is the key. I should be done with grad school this year, and I've already been looking for other positions. I want this designed properly, even if it means living on Extra Strength Tylenol, because I don't want anyone to inherit my incompetencies. I'm...

Currently, I have: tblWeeklyReport ID (PK) INSTITUTION WEEK other fields Staff Injury ID (PK) other fields Assaults ID (PK) other fields Inmate ER Trips ID (PK) other fields etc... I do have a table called INSTITUTIONS, which pretty much serves as a table from which to get values in the...

Hello, In another thread under forms, it was suggested that I try the double, and it works. I need to review the field size types. It all seems to be workign now. Just fine tuning left, which can be good or bad, depending on the changes I decide to make!

A man who is patient? Didn't know such a thing existed? What a remarkable find!:) The double key though would appear to be easier than creating another field. So, I'd just have those same two fields in my other tables, like staff injury? Currently, I have the ID field in each table, with...

I've never done a compound primary key. But, it would simply somehow create a bond between the two fields that would always link the values? I thought though that with a primary key, you couldn't repeat the values. I have 33 sites that will submit a report each week, so for one year...

So, two queries. One to find the data and one to do the calculations? I can work on that. Thanks!

I didn't explain it very well. I'm trying (note the word "trying" :) ) to creat a database to record weekly reports from 33 different offices throughout the state (work for the state). What makes each record unique is both the site abreviation (ABC) and the week. (ABC and 09-08-02). I also...

No, there are records inbetween. I COULD have a separate table for each site, but that would been 33 tables, and the query to join them would be a nightmare! Thanks.

Okay, here is the next question. All the data entry in the form is working perfectly (thanks to the expert help I received). One of the things I'd like to track, both in the form, and in a report, is the % change in some of the figures from the previous week. How complicated is that going to...

It appears to work when I changed it to double. Any idea why it didn't work when I had the field size as decimal?

They don't appear in the table or the form. At first I thought it was the form, so I made sure all the ettings were for 2 decimal places, and and standard. Then, I went back to the table to make sure that I had correctly specified my settings, and I checked the value in table form, discovering...

I did all that. It is set to number, and I changed the decimal places from auto to 2. I've tried fixed, standard, etc. And, I have field size on decimal.

I have a table where I'm trying to enter numbers in decimals. If I type 123.45 I get 123. I tried the help feature, and think I'm doing what it says, but obviously not. I've also tried the various options (integer, decimal, etc.) and standard, fixed, etc. What is the proper combination of...

How can I get the fields to record decimals? I've used the help feature but can't figure out what I'm doing wrong. I know the property has to be set in the table, and I have 2 decimal places, but they revert to 0. I type 123.45 and 123.00 is what isw displayed. Thanks.

When the subform opens, how can I specify the size, so it isn't full screen? Thanks.

Yes. I know how to convert it, and I don't mind converting it. It isn't that difficult. I just wondered if other people prefer Access for the data entry, and SPSS for the analysis.

Do you have any exdperience with SPSS?

SPSS is a statistical analysis program, generally used in the social sciences. I have Ver. 11.0, we can purchase it through school for $17 due to their site license). I've never had it correct things automatically, like Excel. I've always had to re-run the syntax for EACH field that referred...

I'm currently working on my doctoral dissertation, and will have to use SPSS. I'm new to SPSS and after several FRUSTRATING experiences, went to the "HELP" center at school. Their recommendation was to do all data entry in Access, then export to SPSS. So far I've found this method to be...