Search results

Sum I'm not sure at all about this but the problem may be that you are trying to sum a calculated field. May be this will work: Instead of: = sum([txtManHours]) put: =Sum([txtPeople]) * Sum([fldHours])

Sort Assuming the report is based on a query you could try this. Ad a new column to the query and in the Field Row put: QuantityText: Str([Quantity]) This means you have converted Quantity to a string (text type) Then sort this column Ascending And please post your question in only one forum.

Concatenate Ad a column to the query and in the Field row put something like: TotalName: [Firstname] & " " & [Surname] Then in the report the fieldname you will use is: TotalName

City Country Please search the forum. There are many posts since this question is being asked almost daily.

Relationship RV, I usually have a seperate table for contact info since some clients have several departments, phone numbers, extensions, email addresses etc. That way I can store unlimited info without having to create fields in the main table that may not be used for clients that only have...

Relationship I think the way you set up the tables is incorrect. First- and Lastname fields should not appear in 2 tables because it creates overhead and violates the rules of normalization Probably the best way is to have 3 tables: Table 1: basic client info Table 2: contact info (phone, fax...

Format Glad it works. When you use a query you can select only those records you really need, and thus limit the amount of data to be processed. Especially in large databases it will save time. In network environments it can significantly reduce network traffic. You can also ad calculated...

Format It has to go in the Control Source of the field on the report. In other words, nothing is changed in the table itself, the field is only formatted for use on your report. A problem may be the field name you are using. "Number" is a reserved word in Access, rename the field in the table...

Format Put the following in the Control Source of the field: =Format([YourField],"0000000") Replace "YourField" with the actual field name. Happy Easter

Report Not even a 'Please'?

Complete Please search the forum, there are so many posts on this topic.

Report Probably the easiest solution is to put a hidden textbox on the Registration Form, name it something like: HiddenDate. In the Control Source put: =Str([StartDate]) Now you have converted StartDate to a text string. And then change the control source on the report to...

Report May be it's because you try to concatenate 2 different data types. I suppose [Forename] = text and [Date] = Date type.

Focus Place a textbox on the form and make it the smallest size so it won't be visible. In the On Open Event of the form put: Me.HiddenTextbox.SetFocus

Insert Use an Append Query, the ID will be automatically incremented for the new records in the existing table.

Report Search the forum for "print current record", there are many posts about this.

Table Always use a form - preferably based on a query - to ad, change or delete data. Working directly in a table, especially when you have others working with the database, is asking for trouble. Using a form you can control the process, validate data etc. If you let people work with the...

Currency Change your fields from Long Integer to Double.

Great You're welcome.

Box Try this: In the After Update Event of the combobox put: Me.txtCustomerName = cboAccountNumber.Column(1) And set the data source for txtCustomerName to the appropriate field in the table of query