I'm running a query that requires that I convert a YYYYMMDD text formated field to a valid date, then use the converted date to determine the person's current...

Hi! I hope I have this in the right discussion group. Here is my problem: I have a form which is to be used to enter query criteria for up to 14 fields. I...

Hello, I am using Office 2003. I have an access db that contains a number of tables. I have been asked to export two of these tables to Excel. The issue...

Hello everyone, I have a simple dilemma that I just can't seem to solve. I have two tables: tblfromXLS and tblwebmaster. I need to use an SQL statement that...

Hi My webpages no longer show their borders! Last week, for no apparent reason, the web extensions "turned themselves off". This has just been fixed at the...

Hi, I've created a crosstab query, sorting machines by row and parts by column, with count of each parts as the value. Not every machine has every part, so...

I created a simple database that will be used to track company purchases. I created three tables (main, list of departments, list of vendors). I created a...

Hi Guys, This might be a really dumb question, but can anyone advise the correct way to calculate profit margin % I have / i.e £4.19/6.98 = 60% (no...

I have a table with 306 records. If I select the top 33.333333333 percent, it's returning 101 rows. It should return 102 rows. Thinking that this was...

I've converted a select query to an update query where I'm attempting to populate a route (number) field into a primary table using .. The Select query...

Hi, I'm executing the following SQL statement using ado 2.8: ALTER TABLE mytable ADD myfield text DEFAULT('') And get the following error: Microsoft JET...

Dear All, I have table having more than 1000 of rows for every date like Date Amount 01/01/2001 5000 31/12/2005 ...

I've imported some tables from csv files and the month and year fields don't have leading zeros, ie year 2006, is just 6, and month 06 is 6. I'm wanting...

Been struggling with various queries for time/date criteria and have gotten some Fantastic help in this forum... The current query will display all records...

hey all, i have a table of employees and what i'd like to do is group by male and female. but also would like a count of which employees fall in a specific...

I'm creating an SQL statement for use in code. One of the fields that is retrieved is facility area, AREA. The area unit of measure (UOM) could be SF (square...

Hi all! I have a need for creating unique instances of duplicated entries in a new field. An example of my data and what I would like is as follows: What I...

can a query return the last day of a month on a date field for exampy if in date field I have Oct 29 2006 Nov 15 2006 Dec 10 2006 can a query return Oct 31...

I have the following query SELECT NFind.BId, NFind.NTCCY, NFind.NTFs, NFind.NTDueDate, .Type FROM NFind INNER JOIN ON NFind.TypeId = .TypeId WHERE...

SQL SELECT Count(Contacts.StatusJuly) AS CountOfStatusJuly, Contacts.StatusJuly, & ", " & AS FROM Contacts GROUP BY Contacts.StatusJuly, & ", " &...