Hey Guyz, I want to create a query that takes all results in one column (FirstManager)and "pastes" (for lack of a better word) them into another column...

I am doing something wrong and I can't figure it out. I have a crosstab that I am trying to set Null values to "Missing Value". Right now, the crosstab...

i want to make a query in order to calculate volumes in some causes when i make summation i have both negative and positive values i want to get the negative...

I am having a problem doing something in Access 2007 that I was always able to do in Access 2003. Let me give you an example. A simple table with three...

I want to be able to create a run-time executable database that allows the user to open the quesy in edit mode. Any help would be great. Thanks!

I need to calculate at each record a cumulative base on current record + previous record. Not sure how to attack this one?!!! Daniel -- Message posted via...

Hi I'm using len and left function to get a value but the result is #Error. The RATE is in TEXT format with value like 64K,256K. the idea is to get only 64...

I have the following error relating to a UNION query I am trying to write in SQL. Extra ) in query expression (((HEALTHCHECKS.) Between Date() And...

I am using access 2003. I have a query that pulls data based on group by and first in the total row and the data is good. My problem is when I create a...

SUM EXPRESSION IN QUERY PRODUCES THIS EXTREMELY SMALL FRACTION WHEN IT SHOULD = ZERO. ANYONE SEEN THIS BEFORE???

I have a long text string that contains a space two chars for a state and then another space and I want to find that string and compare it to a field in a...

Howdy! I usually prefer Visual FoxPro, so Access isn't really my thing, and I can't seem to find a good example of a SQL query in Access's syntax. What I'm...

I cant get my hyperlinks to up date on the update queries. It just show up on the text to display field, Not on the address field on the edit hyperlink. For...

I have a large data base that is used to print mailing labels... I need to sort the zip codes in a specific order (not accending and not...

Hello all! I am having some issues with the logic on the below SQL formula, and wanted to see if one of you guru's could help me out ;). First off, I...

table info: Alaska $1,200 Product A Alaska 300 Product B Alabama 900 Product A Alabama 100 Product B Query objective: sum product...

I have downloaded a zipcode database and want to use it to find mistakes in my table with 20,000 records. The zipcode database sample records as follows:...

In a sample database, I have the following query. SELECT Null As Title FROM tblDummy UNION ALL SELECT tlkpTitles.Title FROM tlkpTitles ORDER BY 1; tblDummy...

How can we use sendobject to directly send a mail through lotus notes without prompting for a send option.

I am using an Update Qry I have a field that I need to update that is PO Price. From this I have two fields that I need to use; i.e. Vendor ID and Category....