Recent content by calvinsmith

Thank you both for the responses! xaf294, I have tried using your method, but I guess I am a little confused. Why am I creating another table? Is it best to have my data in multiple tables? The forms I am creating currently look at previous year's data, but we want them to look at all data...

I have an access table with 8145 entries, each with a date from year 2004. I need to replicate these entries for year 2005. Is there an easy way to do this? If not, is the correct method for doing this? My ultimate goal is for the user to use a form, select a month, year, and range (i.e. 1...

I have a datagrid that I need to make edits to. My code works great if I make a change to the datagrid and then select the next record. The problem I am having now is that there is a good chance that I will have a user that will make one edit then exit without selecting another record. This...

lbass, Where exactly would I be right-clicking to insert the summary? Would this be in the current formula or in a new formula? If the answer is the latter, I need to be able to perform the summary within the same formula. Is this possible? Thanks for the help! Cal

I have a formula that I would like to sum the values of the variables to give me a total number. This is what I am using so far: [code] if {Plants000.SPECIES} = "ferocactus wislizenii" and {Plants000.DISPOSITIO} = "pip" and {Plants000.HEIGHT} > 2 then numbervar fwislizeniigreater2 := 1...

Is there a way to summarize all distinct values for a given column in my data? What I need to do is create a field that will give the total number of 'A's in a column. The column will be made up of 'A's, 'B's, and 'C's. Eventually I will need to add more extensive criteria for the selection...