Search results

If the project name is in one of the tables in your query you can just add the field to the grid and then display it on the report. If it is in another table in the database you will need to bring that table into the query link to it and then bring the field into the grid. Good Luck GumbyD

I am guessing that your property looks something like: =sum([CurrencyField]) Where the CurrencyField is in the detail or some grouping header or footer. Make sure that you are not trying to sum in the page footer as that will cause an error. You may also want to make sure that you have not...

Just a quick clairification - on the query that runs behind the main report you are only getting on record for each customer? If that is the case then you need to check your grouping levels and the link master / link child setup. If you are getting more then one record for each customer on the...

You could do this with two queries: First use the query you have to get a list of all the customers who have purchased services. Then in a new query bring in the results of the first query join it to the table with all of the customer purchases. Then you can see all the services or products...

Try this one for years and days: IIf(DateSerial(Year(Date()),Month([Hiredate]),Day([Hiredate]))>Date(),DateDiff("yyyy",[HireDate],Date())-1 & " years " & DateDiff("d",DateSerial(Year(Date())-1,Month([Hiredate]),Day([hiredate])),Date()) & " days",DateDiff("yyyy",[HireDate],Date()) & " years " &...

After I looked again I realized that my original expression has some problems. Try this one instead: IIf(DateSerial(Year(Date()),Month([Hiredate]),Day([Hiredate]))>Date(),DateDiff("yyyy",[HireDate],Date())-1,DateDiff("yyyy",[HireDate],Date())) I will enter another entry for the years and days...

I think you have the parameters in the wrong order, but I am not sure. try this: DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp", variableSheetName, False Here is the function parameter order: TransferSpreadsheet(TransferType (acImport)...

Try the following: DateDiff("yyyy",[HireDate],date()) GumbyD

Ok - This may not be exactly what you want - but you can alter it if you want to. You will need to create a query with your main table and the code table in it. The join from the main table to the code table should be an outer join pointing toward the code table. Create the form based on this...

It sounds like you have some default values being assigned when you move to a new record. If the values in the subform are enough to create the necessary keys on the table, then when you close the form it will automatically save the record on close. GumbyD

Deegee - You are going to need to enter the sport names somewhere. There is no way to have them magically appear on a form if they are not stored in a table, referenced in code, or put into a property somewhere. Usually data like yours in handled in a code table where you associated a code...

When you have equivalent values it does not see as the same in a grouping query. Since 3 records have a value of 7 it sees them as equal. Gumby

Make sure that you designate in the query parameters that your input field is a date/time. Then try this: TSales: DSum("[sale]","44sales","[prodfil2_1].[pname1]='" & [prodfil2_1].[pname1] & "' And [st]='" & [st] & "' and [bldate]>=#" & [begdate] & "#")

Set the Unique records properties value to Yes on your delete query. GumbyD

Can you post the database or at least some screen shots to look at? Being able to see the form design and code would make this easier to solve! Thanks! GumbyD

I have seen the XP developer version on a number of sites, do you need to have Access 97 for some reason? I searched for a while but I can not find the Developer 97 edition either. E-bay had some single disks that were just the tools maybe if you got professional and the tools disk that would...

You need to set your recordset value equal to the set of records you want to move through. Here would be an example: Dim rstProducts as recordset Set rstProducts = currentdb.openrecordset _("qryProducts",dbopendynaset) if rstProducts.eof then msgbox "no records in recordset",vbOKonly Else...

Use a combo box with a row source type of value list and then list the possible choices in the row souce property. GumbyD

If you can get your data into a recordset object than you can use the do until loop as follows: dim rstYourSQL as recordset if rstYourSQL.EOF then msgbox "No records in Loop",vbokonly else rstYourSQL.moveFirst Do until rstYourSQL.EOF 'Do you stuff with the record rstYourSQL.moveNext Loop...

Sorry - It looked right at first glance. Stupid question time - What does the developer editon have that the professional editon does not? Could you buy the professional edition and get the missing stuff seperatly? GumbyD