Search results for query: *

ok that got it thank you very much!

ok when i insert the parent record it should give me an expandible list of sub records this is what isn't happening i can insert a parent field but how to link to the sub records in the next table??

I would like to know if there is a way to link orphan records back to their primary table. Cascading tables owners table one to many to wells table some 500 wells have no owner and i need to link them back to an owner in the owners table all 500 have same owner please advise!

That works perfectly thanks to both of you!

OK you guys and gals are great but here is another one what is the easiest way to query from one date to another. Like from 09/01/2003 through 09/30/2003. Or is there an easy way to set it up where you can prompt to enter the dates to query? Thanks David

bingo thank you very much

ok i think i am seeing this so basically put all the results into one table and then form or query out the needed info but let it all be entered into one table insted of six. I can't belive i couldn't see that. i am pretty sure that will work. So there isnt a way to leave them seperated and...

ok in report footer section i inserted a text box and then put Count(*) in the text box and number of tests in the corresponding label. then switched to report view when i switch i get the enter parameter box to enter a parameter for Count(*).

ok when i run the report now i get an enter parameter prompt i have tried it both ways and get the same result either way

Gunny your on the right track but these six inspections all have different results like one has one result true false, then 6 numeric values then 16 numeric values then one has 6 text entries and another 7 text entries, and the last has 3 true false 3 text. so they all really need a seperate...

Please advise best way to build and relate table Owners table to wells table to inspections table fine then i want to go to 6 different kinds of inspections with only one it relates great where i can cascade delete when i add second table for second type of test it messes up please advise. Thanks

I would like to know the easiest way to count and display on a report the number of entries on the report?

Have created a query then form from the query involves 4 tables. form shows in design view but when i switch to form view nada. Nothing shows up please help.

Any hints for moving a database from one computer to another without it becoming read only and loosing form formatting?

Thanks for the help that will work fine I am used to pointing and clicking in excell.

I would like a simple way of doing a calculation in an access table such as one column minus another column displayed in the next column.