In my crosstab query, the short date sorts like: 6/1/04, 6/14,04, 6/20/04, 6/9/04 which although is textually correct does not represent the correct order...

Can a crosstab query list values without aggregating the "value" field? I want to take a table of inputs and basically turn it 180 degrees to show a calendar...

Access 2002. This is a repost with some updates. Once you are on the third of fourth page of the newgroup you are history. Anyhow, here goes. I have a...

B'H This should be easy: I am using a subquery to make a simple calculation within a query. Now I want to see the average of the column that resulted. Is...

I am tring to perform an update on columns within an access table. However at design time the columns I wish to update are undetermined. Is there a way to...

I have a data table reflecting tasks and personnel assigned to complete them. The personnel may be assigned to either of two different roles depending on the...

I have a table that looks like the following: ID ProgDate 1 1-1-04 1 1-15-04 1 2-4-04 2 1-12-04 2 1-29-04 I need to find...

I've created a union query that feeds a report of combined data. The 2 tables that make up the union query have some Memo fields. When the report is run the...

Thanks for taking the time to read my question. In my query design I want to have the following critera in the criterial line for a field =(!/10)-0.5 And...

I am assuming that TOP is what I should use for this query, but I'm having a hard time with it. I have an equipment history table that represts repair detail...

I have a form with some controls on it including a checkbox. I want to know how to change the WHERE clause depending if the checkbox is checked or not. Here...

I have the following datafield LastLengthBack: Mid(,20,3) which returns a sample data of 10 5 3.3 1.8

Hi all, I'm looking to be able to parse data into multiple fields without having to do it manually. The data below is in the exact current format. What I need...

The left function works fine but the Right and Mid functions not so good. The Mid function returns #Error and the Right function is hit and miss. Sometimes it...

When running a query that then exports data from 'Access' into 'WORD', any fields in date format are always changed back into the American system (m-d-y). This...

Hello! In a Form, I have a command button to run an Appendquery. When run it, the query append all records but I would like to add only modify records, without...

I have a query that is extremely slow (takes 59 seconds to complete). The columns that seems to cause the slowness a Inactive:...

I put the criteria in the query for the artist, that reads "" when i open a report or anything that is based off of this query, a box pops up where u have to...

"Microsoft Access has encountered a problem and needs to close." I've been trying to figure this out for a full day now. I have no problem opening up...

I have my records sum and group by date in week number. But I can't get the week number in the right order. It currently output as...