My UNION query seems to be truncating memo fields, even with no grouping statement in the SQL. I am reporting the results of some research interviews. For...

Can someone help with above. I have got DOB but want to work out their age.

Can anyone help me? I have a Table with staff details. One column is TRAINING DATE and one column EXPIRY DATE. Training date is the date of First Aid...

This must be a very beginner question... But I am stumped I have a few tables... Customer which holds most of my information. Status which is a list of 8...

I have a database with lots of saved queries, most of which are interelated. Is there a way of ascertaining which queries use a particular query, so that if I...

Hello, I have a field that comes to us with dashes in it in the format 0000-00000-0 and I would like to run an update query on the field to delete the the...

I have a database that hold s figures for each quarter. I want to create a query whereby the user can ask for the running total of the data upto the quarter...

Hi I'm using Access 97 with visual basic SP6. I have a simple query : "DELETE FROM WCha" I got the message "Could Not Delete from Specified Tables" on 1...

Hello all! I have the following problem. I would like to create a query, which will sum up 3 orders of highest quantity for each department. Here is the...

I need to update a field in a table that is a yes/no check box in the form. How do I write the update query criteria so that the table will reflect yes or box...

Hi, I have a table with: Id (autonumber), Inv_Nr (text), Amount (currency), Payment type (text/lookup). Payment type can be Ca, Chq, CC, Comb. I need to...

I have a 7000 record set in MS Access on a fast server. Broadband connection. Takes quite a bit of time to pull the recordset down to a browser. Makes...

My query references a text box on my form !! to filter records. If the text box is empty (null) I want to be able to show all employee records. Presently...

How could I call the function below (decimal conversion for hexadecimal) starting from a query? And in a form? beginning of the function: Function...

Hi NG, I would like to query two tables and have the query result combined as a new "data table" view. Some of the fields in the two tables are the same and...

After exporting data to Excel from access there is a single ` at the beginning of the record and small square boxes behind every string of characters that is...

Hi I have a query which collects the data I require for a particular process, how do i then copy the results of this query into a new table with an identical...

Hi NG, I'm trying to create a crosstab query, but it fails. The content used in the crosstab is a bit tricky to get and involves several steps. The 3 steps...

I have 2 simple tables. One has IpNumbers in them that I have collected. The other table has ranges linked with country codes. I need a query that will...

I am striking out on this one. I need to be able to run a query that looks for items that exceed 90 days from the current date. I thought Day()-90 would do...