Search results for query: *

I would like to be able to get groups of records in sets I guess. I dont know the proper description for this, but basically I want to be able to take a query and say, give me the first 50, then say, give me just the next 50 and so on. I figure I can pull this off with TOPs and INTERSECTs, but...

Has Anyone ever tried getting access runtime to work on a mac running virtual pc? We have 2 macs in the office, 1 running WinME Virtual PC and the other is WinXP Virtual PC. The WinME one is running perfectly, the XP one keeps giving an error that says it cant find the database file that its...

Using Access 2000. I need a query to do this.. Each rep has a number of schools. (treps, tschools joined on repid) Each school has an estimated quantity field. (04QTY) I need to count, for each rep, how many schools have quantities filled in. (ie john q rep has 5 filled in) I was able to pull...

We need to move our windows 2000 server to a new machine, and want to keep all the files and settings exactly how they are. What is the best way to do this. I have heard about the Files and Settings Transfer Wizard, but I think that only works if you import into WinXP. We just need the files...

Need help on a query here. I have a table that consists of an ID, a color(text), a date, and a time. The ID shows up mulitple times. I am using Access 2000. Sample: 17324 yellow 3/13/2003 4:55:03 PM I need the query to return a list of the ID numbers and the color of the latest change. There...

I have a table with 9 text fields that are either yes, no, or null. I need to count how many records have 1 no, 2 no's..etc. Is there a way to do this. Im using access 2000. -Marty Loftus

I have my users open a Access 2000 database and they all have the runtime version installed on their computer, none have full Access. I dont go through the packaging wizard because they have me change the database at least twice a week, and this way seems to work just as well. I recently added...

I am using sendobject to email different queries. There are over 100+ different queries that will be needed so I would rather not create and save each query in the database. I can change the queries with loops and string manipulation, but I'm having trouble sending out that actual query. Is...

My company has decided that rather than pay licensing fees for access, they would like to use something else cheaper. They designated me as the access guy about a year ago and I had to learn on the fly with little previous knowledge. So basically they would like me to learn from scratch...

I have 2 tables that I am trying to create and set up 1 to many referential integrity, by linking ID numbers. The problem is that not all the ids in table2 have a id in table1. How can I find out which ids in table2 do not have an id in table1? -Marty Loftus