My query is not updatable! Can anyone see why and/or have a solution? Maybe I'm using the wrong joins...? SELECT .SKUID, .Name, .Color, .,...

Hello all! I have a query to count how many records meet a certain specification, which is then routed to a form. (The count is set to count the number of...

Hi, I'm working on a table which contains a colume with strings with different length. some of the strings has "0" before them and I need to delete the "0"....

I have the following SQL for a Union Make table query. SELECT Combine UNION Header-Detail.*, . INTO mktbl_UnionHeaderDetailXT FROM LEFT JOIN UnionHeaderXT...

I have a table that was imported from Excel that contained fields Note and Comments. I want to concatenante the 2 together separated by a comma. As you can...

When viewing the database objects screen, I can click on view/details and see a list of my queries, their description, creation date ... etc. How can I print...

I need to full outer join two tables while simultaneously adding together two common fields. I've read the past posts but am still struggling with getting...

I have three list boxes. Depending on what is selected in the first list box, the second will display different data. Whatever is selected in the second will...

Hi, I need your help and how to default specific query1 and query2 change to READ--only and other query 3, 4, 5 that are able to edit from the form...

How can I have a record with 3 fields and each field is a Count(*), I mean how can I combine three queries below into one query? SELECT Count(id) as...

What is the syntax for creating an update query with the new information as a subquery calculation. This is what I have in the SQL statement, but an...

I am filling a dataset in VB.NET with randomly chosen records from a table in an Access Database. I use the following SQL statement that works perfectly when...

K, I want to execute a query using a Like "Criteria" statement and display the results to a form but I also want to be able to add new records using the same...

Hi, I have a database with two tables. One contains resident information and the other contains assessments. One resident can have many assessments. Each...

I have a log file with a date created using now(). I want to select log records that fit within two dates passed to it by another form. the log date is date...

Hi group. one of my tables has a field with product number that is flanked with double quotes. The length of the product number can vary from 3 to 8. Eg. ...

Hello! Could someone please tell me why this query does not show top 20 Products ordered by Hits? SELECT TOP 20 Id, ProductName, Hits FROM Products ORDER BY...

Instead of finding the "lowest" value of a records set (e.g. "5" out of a record set "10, 5, 70, 25, 30, 100"), I'd like to find the "lowest three" records.......

Is there a command to export a table to excel in one shot with VBA? I know how to do it with DAO, running through an entire recordset populating cells based on...

I have a function that gives me the UserName with which the user is logged into the network. In other word the function returns the network login name. In my...