Search results for query: *

THanks for the reply - I actually found that you need to enable the subform to be editable! Go figure. THe query could be edited from the query results window though! Thanks for your help! Chris.

Hi, I have a form that I am trying to work with. It is getting data from two tables and I'm trying to manually enter data into the a sub form of the main form. Basically, I have a form with about 30 fields from 2 seperate tables. All but one of the fields is to marked as not modifiable - i.e...

Hi, Thanks for the quick reply....this just returns the total number of entries that match EN_PS1% I need the number of the number of entries that match EN_PS1% for each unique entry in 'parentkey' i.e. there might be 5 different entries in 'parentkey' used many times. parentkey1 = 100...

Hi, I am new to MS SQL Server 2000 and have a really simple query I need help with. Right now I have the following query: SELECT * FROM dbo.scores WHERE (testKey LIKE 'EN_PS1%') This of course returns all the rows in the table where the testkey is begins with EN_PS1 However...

Hey, Thanks, this works GREAT!! I have one more question...... Is it possible to create a seperate table for each entry in the datfile when you run the query. For example, for EN_PP9 there is one table, for EN_WD9 there is another table with all the corresponding entries from RESULTS in each...

Hi, I have no idea about Access and SQL Queries but have the following task assigned to me! I have the following: 1 access database with 1 table called RESULTS. 1 column of this database is called DATFILE - this is a text field with an entry for every row. Many of these rows contain the same...