Hi All: Using Access xp dev. Is it possible to write an append query that appends records from one database to a different database? Thanks, Ed

Using Access 2000, I am trying to make query for production based upon two variables; "Location" and "Employees." Each location and each employee is assigned...

I have the following calculated field in my query: Total Paper: nz()+nz()+nz()+nz()+nz()+nz()+nz()+nz()+nz() In some records I am getting, for example, $26.80...

Hello, I hope someone can hep me. First here is the query (Thanks John and Bill) PARAMETERS DateTime, DateTime; SELECT FSAClients.EthnicGroup, Count(*) AS...

I am trying to do an update of a column with data from another table. The following T-SQL UPDATE titles SET ytd_sales = titles.ytd_sales + sales.qty FROM...

Hello, I really hope someone can help me...I am a novice at this....and here is my problem. I am attempting to create a database which tracks the spending of...

I have a large list of names in a database table which includes things like account # and Date of Birth, Address, etc. I want to run a query looking for...

I have a report that the user would like to type in only the month and Year in the following format: Jan 05. Then the report would show the report with only...

i have a huge table and have several records that are duplicates, is there a way to get rid of one of the records where the loan # is a duplicate? ...

As suggested here I made two switch queries but, after many attempts I have not been able to work out a way to select correct query to use. If 8 years service...

I have the "many side" of a one-to-many relationship (i.e. multiple rows) and I want to flatten this to make these rows into columns. I am trying the pivot...

I've got a form with some comboboxes, five checkboxs and a command button on it. The command button simply launches a query. I'm getting some very strange...

Hi I have a query that is not updateable in either the query or form views. Any assistance would be appreciated. SELECT subtblClientPolicies.ClientPolicyID,...

Hi, I have a table that has a list of accounts I want excluded for a query. Basically, I want this table to be updated by users with any accounts that should...

I have 2 queries, one to append data and the other to delete data, they both use the same parameter (=) I run a macro that combines the 2 functions in one...

I have a large list of names in a database table which includes things like account # and Date of Birth, Address, etc. I want to run a query looking for...

HI all, I am confused with how to tackle dynamic query/Report situation. I Have a simple query which has some fields from tables and then some calculate fields...

I wil try to make this a brief as possible. I am working on a database to keep track of student information in an alternative school. To do this I have...

I have a database with one table which is related to 5 other tables ie. field productid in main table ties to product table with all details on that...

Good morning. I am trying to add sql code to a query to determine if a field (Test01) is null. If it is not null then I want to add 1 to a counter (TotPts). ...