Search results

I have a Design Master that I use for many replicas. I would like to replicate the design master so experimental changes to queries and tables can be conducted without exposing the "real design master" to errors? Each time I replicate/copy the design master the replica/copy will not allow...

I have a form for entering data. I use a combo box linked to a table to select a record that has a person's SSN, Name and city. Once the proper record is highligted and selected only the first column is visible in the combobox. Is there any way to keep all 3 columns visible once a record is...

I have imported an Excel spreadsheet that is basically a crosstab table that has a column for a code for the service, a column for the description of the service, and many columns for the cost of the service by region. Is there a way to display all the service codes, all the descriptions of the...

Thanks, but this doesn't do the job. I want to get all the information in the query and use the query for a report. If the subscriber is a single member, the count and the sum of members are equal so no problem. With the family plan, I count the number of plans and sum the number of members. I...

I have a table that I compare to a query. The Query lists all the states we have business. The table has the state where a client is located and the number of members in the group if it is a group business or individual member if it is an individ. member. I have a second query that totals...

Thanks for the advice, but being a novice I am not clear where this code should go. Everywhere I have tried it I get an improper syntax error message. Where should these calculated fields be created and what should they be called?

I have a database that has a field for a procedure code and a field for the amount paid for the procedure. We can pay for the procedure-(+$), not pay for the procedure ($0), or backcharge (-$) for a procedure. I have a query that lists all the procedure codes that were done for the month and...

I am comparing 2 tables. The first table has a list of the states and the second has the state and # of clients. If there are no clients in a state, I need to return a zero value for that state. Can this be done?

updating table Thanks for the advice. I usually don't use subforms, because it was easier to use separte pages(forms) for each table, but I will give it a try. Thanks for the advice.

I have 3 forms tied to 3 tables that are all used to complete a report. I type the last name on the first form and use it on the 2nd and 3rd forms to tie the forms together. I take the name typed in the first form and use it for the default value in the 2nd and 3rd form. I use the corresponding...