ok...here is the sql of what i am working on, maybe this will make more sense to someone out there... 1) First qry gathers data from the Sales Order files in...

I have to following Access2003 Code that needs to run in SQL 2000 SELECT extend, Source, Count(PersonalID) AS RecordCount, Count(IIf(0,(),Null))...

I need to update a table with a sequence number for the records. The sequence number should be primarily based on the ID field, then followed by the DATE and...

Here's the sample content of my table: Worker Date Task ============= Worker1 Oct 1 Task1 Worker1 Oct 1 Task2 Worker1 Oct 2 Task1 Worker1 Oct 2...

I have 2 tables. One for softwareTitleOwners and one for SoftwareOC (out-of-compliance). The table for Software that is out-of-compliance simply has a field...

I have a membership db where I have a date field that tracks the date they joined. January starts the new membership year. Throughout the year, we have...

I need to query a field based on date alone. The data also contains the time component. When I query as dd/mm/yyy (i.e. #04/19/2000#) I get no results - if I...

I've got a problem I've come up with and I'll try to explain it best as possible. I've got an application that has 4 fields. Contract Number, Contract...

I am working on a course where people taking the course can ask a variety of people questions. Each person has a default number of questions they can...

Hi, I'm using Access 2003 and have a field that I want to split into 2 seperate fields. This field has a Carriage Return imbedded in the middle of the...

I have a table with a field ShipDate. In another table there are fields ShipDate1 - ShipDate12. I need to create a report that shows shipping dates broken down...

Hi, I have this field , which I use to enter data on a daily basis. I would like to know how to display this data, in a 4 weekly basis, instead of a daily way...

I have a file with 2 columns. One is a column of zip codes, and the other is a column with random numbers in it. I would like to run a query that matches up...

I have an update query that's not updating correctly. I want to find a value in the Temp table by asking the user for input then change that value based on...

I have a query that generates a summary for different sites, is it possible to update fields in another table with the summaries generated in this query.

I have a Customers table and an Orders table. A CustomerNum field links the two tables. The Orders table has a Source field containing a number that indicates...

Hello all I have a table of data with the following fields "Date" = Date/Time "Remarks" = Memo Sample data = 27/10/2005 10:13:04, "Event stated by...

Hi, I'm trying to fill a combo box with all dates from a specified date until now. Basically, what I want is something like "Select Date Where Date...

Attached are the DB table relationships. I have an Access 2003 database that has several tables in it that are all related to a client table and have the...

Hello, When I use 'Max' in a query in a date field. I do not get the correct records for the fields associated with the date field. I do however get...