Using: Classic ASP, MS Access, Jet SQL I have a users table, an occupation table and a resolver for the n-n relationship between the two first. CREATE TABLE...

Hello, Hoping someone can help me out, would be much appreciated. Here is what I am trying to do: I have several tables, each with 46,000 rows of data. I need...

Hello, I posted this in the wrong section, and am reposting it to the 'Queries' help section: Hello, I am trying to write a query that will show me the Top...

I want to search for registration numbers within tables, these numbers may have embedded spaces. Also the registration number typed into the search form...

I have a Frontend on the PC of every user, a Backend with the tables on the server. The Frontend has also one table (which has unique records for every...

In the sample data below I have the problem that two identical vendor IDs have different descriptions. How can I create a query that would isolate all of the...

This is my first attempt at using dsum() in a query and I almost have it, however, the running total is running in the wrong direction. SELECT...

I have a table called tProjectDetails it has 2 fields called FT and RD which are checkboxes. The table data looks like this... ProjectID Unit FT RD 1 ...

I'm not even sure where to post this, but I guess this is as good a place as any... I was woking on a database and attempted to open an update query in...

Hi, I'm able to create average in Part A, B, C, D but couldn't do average in All Parts in a same query. Avg Part A - 25 Part B - 30 Part...

Morning Gang, I look after events and have a do...loop piece of code to create block bookings (please see at the bottom). As part of this do...loop it gives...

two questions- 1- how can a screwy default numbering system be changed to normal ? ex: 1,2,3,4,5,6,7,8,9,10,101,102,103,1001,1002,2,3,4, and so on to a normal...

I need to move data from Table 1 to Table 2 and can't figure out how to do it. Perhaps someone can help me. Table 1: has 3 fields DealerID Car ...

For example: SELECT Count(table1.) FROM table1; But table1. is duplicated, how do I use word distinct, or other way to count distinct number of table1.? Many...

There are two table , Table1: name ,city ,salary, Table2:city, province Query1:SELECT table1.name,table1,city, Sum(table1.) as sumofsalryofperson FROM...

I have a table of a few hundred thousand records that contains address fields (AddressLine1, AddressLine2, AddressLine3) and in any one of these fields could...

Hi there, I've got the following SQL but I'm am getting more results than I want because of ties. SELECT TOP 5 Warehouse, Count(OrderId) AS...

I have a table with dates. I need to have it look down the table to the next record and if its within five days add two dollar amounts together.

I have a database that records appraisal records for a group of people dating back to 2001. Various details are registered including the appraisal date and...

Hi everyone, I'm trying to concatenate records created by the same user for the same customer on the same day at the same time (working with AS400 & each...