Search results

Create a new MAke Table Query, where you set the First query as what you want the Make table query to use. Make Table Query is one of the selections in the menu for query type, along with Delete, select, append etc

Hi Is there a automatic way i can delete Fields from a Table? This table gets input into the database very frequently as updates come in and i'd like something like a Query or Macro, where i can define which fields i dont want, to delete the 30+ columns of useless data. Can't see how to do it...

Groovey, thanks

Hi i have a query that takes fields from various related tables to give me the information that i want The primary table has 199955 records The query displays only 199939 16 recordss are missing I know why this is: the primary table (CWT reqd equip) has a field on it that is a primary key...

Thanks a lot i've done that and it worked

Yes i'm having trouble with a Count problem, don't laugh at me. I've got a query with 200000 plus records. Each record has an equipment ID number (its not the primary key) in column B. I just want to count up the number of records that have each equipment ID code, but im not sure how to do it...

Hi i have a query that shows 190000 records made up from related fields spread over many tables. now i add in a new field to the query. It is related in the same way the others are, and indeed the information now appears in the query matched up correctly. But for some reason the query now...

Hold on I do have it! YAY!

how do you make a totals query?? i thought i had it but my i dont, i really really dont.

i did that i couldnt get it to work???? anyway i've done it using the query wizard, thanks

??????????? apparently i cant do it in the query? I have no idea what or where to write something to add up all the numbers in a column that i have in a query. Whats the easiest way? I cant export it to excel as the query has 200000 records thx

what form function should i use? thx

Hi How do you add up all the values in a column in a query?

Thanks everyone that was it, i needed the two "not likes" seperated by and And. Thanks again

Access had autochanged it when i saved, but there is no change to the outcome of the query It does say dataset not updateable in the bottom left when you change from design view to view what changes the query will do. Anyone know what that means? thanks

Hi I think you first want to use a select query to get all the records with "done" in them. Run this just on the table with this data in. Then use a create table query on this select query to make a table. then use an append query on this new table to add the data to another table dead easy eh

Hi I have a select query and im running it with Like "*pendant*" in the criteria of one field so i only get the records that have pendant in this field but i have added another criteria, Not "6077" in another field, so i get records with pendant in field one so long as they dont have 6077 in...

oh hold on i've worked it out, it's really easy. Not concentrating very well, i wish they'd hurry up and issue popbitch so i can stop working.

Hi I cant seam to find many examples of Criteria expressions you can put into queries. I now the basic stuff like "like" "not like" and doing anything with numbers is straight forward. Is there a examples list anyone knows listing all of the types of exressions you can input? At the moment i...

I redid the query using the wizard to do the start bit then edited it in design view and it works. Ill try the same for the append query, thanks for the replies