Search results

Hi all, I am trying to link an Access Query in a Word Document and I am getting this error message Error! No topic specified. Can any explain why the link is not working and what does the error message mean?

Hi everyone thanks for the help. Wilklendt your explanation has given me a better understanding of what is happening. Thanks again.

Hi everyone can someone explain to me in english what the following sql is doing step by step: SELECT OD.OrderDetailID, OD.OrderID, OD.OrderDate, nz([orderdate]-(SELECT max(OrderDate) FROM tblOrderDetails WHERE OrderID=OD.OrderID and OrderDetailID < OD.OrderDetailID),0) AS DaysBetween FROM...

Hi everyone, This is my first attempt at using sql. I have created two queries based on sql that I found in this forum. I am attempting to calculate the difference between loan amounts in subsquent records of a table over a group. Below is a sql view of the two queries: SELECT Project.PrjtID...

Thanks and yes it helped.

Hi everyone how do I print the design view(field Name, data type, description) of a table. Thanks in advance.:confused:

Hi, everyone is there anyway to print a table in design view(Field Name, Datatype, and Description)

Hello, I have a table (Projects) with original projects and amended projects. All information regarding each project is inputted in the fields for original projects. Only limited fields are inputted in amended projects;new loan amounts or a new closing date may arise infrequently for amended...

I have a table with a commitdate and a closingDate. I want a running sum of the City$ field. I only want a running sum of the City$ of each closing date that is less than the commitdate. Can this be done in a query? Thanks in advance.

Is there some way to use datediff to calculate how much time has passed between two dates in one field. I have a closingdate field that can have more than one closing date for a project. I need to how much time has passed between the first closingdate and the last closingdate. Again, a project...

Currency Thanks a lot it worked!

I have used NZ([funds]) on a currency field. My numbers now appear like this 1234567. I want them to appear like this $1,234,567. How do I format this field to appear as dollar amounts and incorporate the NZ() function? Thanks in advance.

I created a report where I set hide duplicate to yes for all fields in the detail section. The problem is that for those groups where there is duplicate info blank rows are printing. I do not want the blank rows to print for groups of data that have duplicating data. Is there someway to fix...

Yes I was talking about the Index window. And no I did not have the properties index set to Unique. Now that I have it set to Unique it works fine. Thanks

What do you mean by set them as concatenated? The first column and first row of the index is called address. The second column of the first row is field Name. The first column of the second row is blank and the second column is field Name. Is this not correct. My Primary key is an autonumber...

I have a table w/buildings addresses separated into fields: One field has street# and the other field has street name. I set an index for these two fields so the the combination of the two fields will not duplicate. Unfortunately, the index does not work; It still allows the input of duplicate...

Hello all, I have a table with two fields set as primary keys to form a unique identification. I want to use these fields as a lookup column in another table and be able to enforce referential integrity. I tried doing the lookup field using only on of the primary keys, and I cannot enforce...

Thanks for your quick response. The reason I was thinking of changing the primary keys is so that it would be easier for the data entry person to not have to enter an unique ID for each new record added. As it would cause to many problems to change all the primary keys, I decided not to.

Hello, I have a DB with 17 tables and most of the the Primary Key for each table is alphanumeric. I want to change all the Primary Keys in each table to an autonumber. If all my tables have an autonumber as a Primary Key would this cause a problem with creating queries or forms? I am a novice...

I'm a novice at access, and your opinion would be helpful. Is it ok to use autonumber as the primary key for all my tables. I have fifteen tables and I am using autonumber as the primary key in two tables the others have have created my own unique primary key field. Also, in a many to many...