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 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...

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

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...

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...

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...

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...

I am trying to modify a query that is a subreport to a main report, but when I try to save my changes, I'm getting an error message that says your changes cannot be made because you and another user are attempting to change the same data at the same time. I am the only person who has access to...

Is there anyway to refer to a font type, such as bold in a query. I want to create an iif query to say "need ltr 2" if text in a field is bold type. Thanks in advance.

How can I use one of the date functions to return the date for every saturday in a year. I have a timesheet report and the weekending date should always end on a saturday. Thanks in advance.

I have an access data with 15 tables. Because my program has projects that can have several different situations per project, I have to create several many to many tables. My question is can a database have too many tables? It appears that I have to create yet another table with a one to...

I have a report with a footer which appears on the bottom of each page of the report when the report has more than one page. Is it possible to have a footer printed on the bottom of the last page of the report only? Thanks in advance.

Hi, Is it possible to separate results of a query by tab stobs. I have a query which give me a list of people to distribute a memo to. I need each person on the list printed across a report separated by tab stops. Thanks in advance.

Hi everyone, I do not know if this is possible. I am trying to create customized labels by creating a report. I need the report to have two equal columns with ten rows. I want each row to have specific titles that I type in and then fields from a query. I want the titles and a project field...