Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ppullag1

    Formatting the numeric values to two decimal places in Access reports

    Thanks Earthandfire for the reply but it did not work. The control source I used is a calculated field in a query and I just used the field from the query as the control source, if that makes any difference. I tried the format command but it did not work.
  2. ppullag1

    Formatting the numeric values to two decimal places in Access reports

    Hi there, I am trying to format my calculated fields in an Access Report to have only two decimal places. I tried setting the property "decimal places =2" which did not work. Then, I tried setting "Format = Fixed ", "Decimal places = 2" for those fields in the reports which also did not...
  3. ppullag1

    Problem using a combo box value in a query

    Thank You guys......I works great....Appreciate your time
  4. ppullag1

    Problem using a combo box value in a query

    Hello Group, In access 2003/VBA environment, I am trying to take a value from a combo box and use in the WHERE clause in a query and open the query as a recordset. But it throws an error "No value given for one or more required parameters" . It prints out the value from the combo...
  5. ppullag1

    Handling date variables in SQL statements

    Hi there..... I am trying to get parts of the date from combo boxes in a form in Access, combine them to form a date and insert it into a table. I am able to extract the parts and form the date but I am having trouble inserting the date field into the table due to some datatype conversion...

Part and Inventory Search

Back
Top