I have a primary key auto number field. I would like to create a make table query to randomly return every 9th record. Anyone know how I would do this?
I have a recently compacted & repaired 236kb Access2K file. I have four tables linked (coming from other compacted databases). I created a union query which contains the following sql statement:
SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileB
WHERE [2 Male]...
I have a recently compacted & repaired 236kb Access file. I have four tables linked (coming from other copacted databases). I created a union query which contains the following statement:
SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileA
WHERE [2...
I have a recently compacted & repaired 236kb Access file. I have four tables linked (coming from other copacted databases). I created a union query which contains the following statement:
SELECT [2 Record_id], [2 Email_addr], [2 Male], [2 State]
FROM 20020408EFXMainFileA
WHERE [2...
Wow, Terry... You are a wealth of knowledge. I can't begin to express my gratitude. I am anxious to check out both MSDE and review the links that you provided. Again, many, many thank yous... mp
Hi Terry, Thanks so much for your quick reply. I didn't realize that MSDE and SQL Server were similar. I'm not even familiar with MSDE so I checked it out on the web. But it looks like MSDE also has a 2 gig file limitation. So I don't think it will be a viable alternative for me in this...
I see from the Microsoft Web site that you can download a demo version of SQL Server 2000 Enterprise Edition. Does anyone know of a demo for the Standard Edition? I work for a very company that may never be able to afford the cost of the Enterprise Edition--however, I'm hoping we can make use...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.