Given a table with the following: ID : int (autonumber) ParentID: int (nullable) Information: string .... and a self-join, where if a record has a Parent,...

Hi, I'm trying to make an append query to update a table in my database. The source for the query is a form. There're 2 textbox that will define the range of...

I have a qry with a subdatasheet. I want to alter the fields in the subdatasheet. How do I find the name of the qry being used as the subdatasheet?

Hi Everyone, I am importing records via excel from another program. The problem is some fields has different values then usual. See below...

I have two exactly the same databases, and now I want to join all the data/records into just one database. If I would like to add all the data from one table...

My original query reads as follow: SELECT ., RACK.Code, .PRODUCT, .ContainerDesc, ., RACK., RACK. , RACK.CURRENTINVENTORY, RACK.RESERVEINVENTORY, RACK.,...

I have a query with a start date and end date and they are date/time fields it is set up dd/mmm/yy format. What I am looking to do is in a query have it...

I have address data that looks like this "P O BOX 123" I want to replace "P O BOX" with "P.O. BOX" To end up with "P.O. BOX 123" All the options I've tried...

I have the following IIF statement in a Query and it is working just fine. I am having trouble adding more conditions to the statment and I would greatly...

Hi - I have a table of date based data that I wish to view as a cross tab with my dates as column headings. For example, for a particular location say I have 3...

Hi I wonder what the difference is between writing the condition 1) not in (2440,1042) and 2) 2440 and 1042 I have never understood the difference but...

Hello, I am desperately needing help with this query. Basically, I have 4 criteria that I want the query to evaluate correctly in a form. User has 2 fields to...

Hi, I'm trying to find a value in table F (Foreign Exchange Rate) that is the closest to the date I purchased a product specified in table P, so that I can...

I would like the results of a query to be copied into a word document. Is there a way to do this in code? For example, a button clicked will create the query...

Hi I dont know how to decrease space between top of page and top of report header. I have a lot of space between these and I would like to use this space to...

I have a field that contains data as shown below: Record 1 CN=McGhee\\, David M.,OU=C4A_OA-Dallas,OU=Users and Groups,OU=OIG,OU=LAN...

Is is possible to write a query that would search a hyperlink. I have a hyperlink in Access that links to a large Word document and when i run the query i...

I have a table of orders called ‘tblDuesod’. I want to calculate the total cost (EuroSodCost) of the orders which have a delivery date (DelivDate)...

How can I query by quarterly, semi annual and annually... for example by year of 2006..i'll do have a table coming from way back 1998.. can you pls help...

I am using access 2007. I don't know if that makes a difference or not. If I want to output an access query to a text file, it is putting like a "printed...