I was modifying a set of queries and somehow Access added 'As Expr1', 'As Expr2' etc. to the end of every column selected. This made every query that used...

I have a report based on a crosstab query. It queries the results of ad sales by sales reps. Sales Reps is a row heading and the Issue is a column heading. ...

Hey Guys, Anyone know how I can check for carriage rerurns in a memo field and if thier are any strip them out? I am only a basic user of access and use the...

this is going to drive me to drink...again, could someone put thier evil eye on this query and let me know what is wrong. trackingnumber =...

Query will not run I get the error: "Operation must use an updatable query" UPDATE PHSCO_Elig INNER JOIN dbo_Tbl_Co_Refraction_Plans ON PHSCO_Elig. =...

Hi Folks, I'm sorting a bunch of codes in Access2000 that are stored in a text field and contain a good number of dashes (-). As I understand it Unicode data...

I am sure that this is easy, but I have spent a lot of time trying to resolve this issue and I have not come up with a working solution. I have 2 tables: & ....

SELECT tblOne.Contract FROM tblOne IN 'D:\Database.mdb' 'D:\Database.mdb' has a password-- ?--PWD='dirty'-- Ed

The following is what I have managed to put together so far, but it doesn't seem to quite work, It generates a list of all users of certain equipment and some...

Hi, I currently have a query with a list of calls from a call log database. Within this query i have LocationDesc and Practice. I want to group the...

Hello, I have a query that collects data based upon date and time. I can drop the date element if I can always obtain the last 24 hours worth of records. Our...

This is probably very simple but I can't figure it out. I want to create a query that will show only the items that don't match between two tables. Thanks...

Hi group, I have a field that has numbers includig zeroes(0). How can I covert the zeroes to NUll( blank to be displayed). Thanks group

Hi all i am getting Problem with default word in Create Table statement Create Table test2 (Id autoincrement, name text(255) , age int not null default...

Please help I have written code to dynamcially enter information in text boxes when the form opens to be used as criteria for a query. However the query is...

In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of...

My assignment's due date is approaching. I'm nervous now! How can I build this sql statement in a function: SELECT LAST(fieldName) FROM (SELECT TOP p PERCENT...

I have a form that has 6 options to select. Then I created a query to return the values that were selected, going good. My question is the query returns the...

I'm trying to create a query that will find the maximum value for a field and if that field is null it will still display the record but the max will be blank....

In my Access 2000 mdb I am trying to create a report that must choose the correct mailing address to send the letter to... The database holds 3 sets of mailing...