Search results for query: *

We have created some Impromptu reports based on direct SQL rather than through catalogues. These reports worked fine with Impromptu version 7.0 We converted to version 7.1 last week and now some of the reports give 'DMS-E-SS_SYNTAX error number 239' error and will not run (I have not reviewed...

I have numerous records in 1 table. I have many different record types and each record may be 1 of two different status values - 'A' or 'B'. I want to print 1 line for each record type. I want that line to show the type and the total # of records for each type and the total # of status values...

I am trying to clean up an Access 97 dB. I know I can get the information I need by looking at each individual Form and Report, but there must be a simpiler way. Is there a process that will show me the 'Record source' name for Forms and reports. Is there a process that will show me all...

We are a small utility company and everyone is connected to the same databases through servers. My query 'groups' data by various fields. One of these is the 'text' date field named 'ILCRDJ'. The field in the query is Month:Month([ILCRDJ]) The first two records have values of...

MS Access 97 - I have to calculate 2 tax amounts based on a subtotal amout. In Query (Total = subtotal + tax 1 + tax 2) subtotal = 25.3333 tax 1 = 50.333 tax 2 = 25.3333 Total = 100.9996 When I print the individual fields on an invoice or display in a form as 2 decimals, I get subtotal =...