Is there a way to do an append query and set a particual field to a value in all records appended? I am currently using for exmaple: INSERT INTO SELECT *...

Hi, I have Access 2002 on XP and when I try to send part of a database via Mail recipient it only attaches the first two lines of the database whether I...

I'm learning SQL, and have two questions. The book I'm using has the following SQL command: SELECT tblClients.Organization, Trim( & " " & ) AS Contact,...

I have a table call , with two columns one is and the other is What i want to do is in a form have this two fields on it but have be a dropdown menu of...

hello i have a database in which i have a linked spreadsheet. the spreadsheet gets updated using excel on a regular basis (data gets added on to the end of a...

Is it possible to use the check box format to sort through a query? For example can I use all records with the box checked as a criteria entry?

I am trying to upload data from a spreadsheet in to my database. I have imported the data in to a table which I want to append to the relevant table. When I...

Really peculiar problem - I've got a module that outputs a web page based upon the results of a query, but the recordset I'm using is returning some bad...

On one pc I receive a message "Query Too Complex" On a 2nd with a duplicate copy of the same database, no problem. Is there a setting I need to adjust on the...

I have a table that contains two dates. One date is the date of discharge (dod) the second is the date the paper work for discharge is completed (DC SUM). The...

I am trying to return a zero on all negative numbers. How do I do this if my field is a calculated field? Thanks, Joy

I am trying to run an update query and MS Access fails to update any of the records because of type conversion failure. I am not sure what this means, since...

Good Morning, I have a survey form filled out by 712 people with multiple questions with multiple answers. I want to be able to query between multiple...

When a parameter is used in the criteria of a query, where is the info typed in by the user stored. I need to access this info to use as a determinate for...

I am totally stuck - any asssistance would be great! I have an append query which appends clientID (from table Clients) and instanceID (from table Instances)...

We noticed this recently, when I do a query for a specific serial number, the item wont show up in the query results. Most serial numbers will show up with the...

I have Date and LN_No in one table and Date and NoPeople in another table. I want to bring these two tables together so they are group by date, Count of LN_No,...

I have a text file that is created each day by a program, I wish to import this into a DB. Is there an easy way. 1st problem is that the file name is...

I have a make table query and I'm trying to sort on a field entitled type code: I only want to see the following types: R01 R03 R15 R21 R22

I have a table that contains two date fields (DOB & DOD). I need to add 21 years to DOB and add 7 years to DOD and then compare the two results and place the...