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...
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.