I need a query that will delete the top 100 records from the table, but I'm getting a syntax error. Here's my code: DELETE TOP 100 * FROM...

LS, I have the following problem. I have to tables containing data. Table 1 contains sales data up to month 9, while table 2 contains forecast data from 10...

I am designing a database to keep track of multiple sales. In one table i have presale information and when the item is sold i put a sales number on it and...

Hey all... my IT guys are stumped... and frankly so am I. I have a DB with four linked tables. I can open my main table in Access 2k and see that all of my...

I have a table of 600,000 records. I need to export 100,000 records at a time to an excel delimted : file. So that I will have 6 files. How do I create a...

Have been trying to find what characters mean in a 'like' query. See that means numeric characters 0 thru 9. So what does *, # ... mean. I have been unable to...

I am using Office 2003 on Windows XP. I have a query in the general design of the following (I have tried to simplify it using generic terms - hopefully my...

When I create a Crosstab query, there are always some blank entries Because there is actually no data in that combination. Is there anyway to give it a...

Hello, In the Table I have 3 col. ID Name Country 1 Boston Bank USA 2 Boston Bank Canada 3 Boston Bank Paris ID is the...

Hello! I need a query that will printout all of the column names of each table. Someone has done it before but that person does not remember how they did it....

I currently have a database similar to the following (but with many more committees): Name Asset Committee Mike Smith x John...

When running the following query in Access 2002, I am able to see my results in the data sheet view, but upon attempting to save the query, the...

I am new to writing code in access, but have managed to build a large database, with security and the works. I've been pulling my hair out trying to figure out...

I have 2 spreadsheets that have about 13 fields for each one. I would like to link the information all together but showing each field for both spreadsheets is...

Hi! I would like to make an editable continous form, where most fields will be from table A and editable, except 1-3 fields are a glimpse into table B and...

I am attempting to collects data from a table and tally totals based upon month/yr that its datestamp is. What I need to do is somehow extract the data for a...

Hello All, Hopefully this is in the right forum. Hopefully what I am trying to do is fairly simple. My employer has two simple Customer Paradox tables that...

I have a table which contains the following fields (which represent results): Score, Team, Opponents I needs a query that will return the highest score for...

MS Access 2002 SP-2 Windows XP Professional SP-2 Is there a way to have Access ignore records of a query result set if particular conditions are met? I was...

I have a very simple query that is pulling all information from one previous query. I have a field called "Area" that I want to be a user-entered field (the...