InfoPath Dev

Hi Hilary, I have been able to get into the form....however, the Grand Total did not calculate correctly. I put in 10 in the 1st column and 20 in the 2nd column - the total calculated correctly on the row as 200 I then inserted a new row and put in 20 in the 1st column and 30 in the 2nd column - the total calculated correctly as 600 on the ...

Thanks so much for the example however, I need a username and password :-)

Sorry...I jumped the gun. :-) All works fine until I introduce a repeating table. In that section I have Quantity and Unit Price.  These two fields are linked to my main data connection.  Naturally I wish to extend the total for each row in the table, and to then have a Grand Total for all rows (of just the extended total). My next ...

All working just fine now......I suspect my problem was that my "where" clause was not querying the correct field :-) Thanks for your help

Hi there, I have a form based on an Access 2007 database.  The form is a Purchase Order form. When "submitting" the form I would like to save a record in the database PLUS send an email to a person who can either Approve or Reject the purchase order before it is sent to the Supplier. On the form, I have 2 approval sections, as ...

Actually the POUserID is populated with the userName function. The UserId is the field in the secondary data source. The formula is trying to say "find the phone number in tblUsers (in Access) where its UserID (an indexed field) = the POUserID (as found on the form). I do not get an error, but no data is returned.

Another way of looking at what i am trying to do is as follows:- Requestor                 Contact Number    Contact Email gary.burke                 614 123 ...

Thanks for the reply. For 1 I did not see this as being a repeating table or section. I have a field UserID whose contents is the function username.  I wish to have a couple of other fields to display the user's telephone number and email address.  These 2 pieces of data are found in the table tblUsers.  How do I use ...

Hi there. Am new to all this :-) I have a template file created based on an MS Access database. One of the controls on the form is populated with the function Username.  I have a main datasource, being the table in the access database where I wish to store the data from this form. I have a number of secondary data sources, being tables ...