Search results

I'm trying to append a query that calculates percentages append that query to a table. When I open the table the percentages either show up as 0% or 100%. I have set the field in the query to percentage and the corresponding field in the table to long integer/percentage and still can't get it to...

I have a button(cmd1) on a form(Form1) that I want to have open a different form(Form2) to add more detailed information, add a new record, and set a field in Form2 equal to the primary key of Form1 without having to add Form2 as a subform. Anyone know of any ideas or have code for that?

I actually just tried to recreate the lookup table structure and add the values back in and that AFTER I restarted my computer. For some reason (not complaining) the "No" and 0 values diasappeared. I really do appreciate the help.

When I do a query the No and 0 values do not show up in the bound fields: Here is the SQL for the 2 combos: SELECT [lkpJQR].[dep], [lkpJQR].[office], [lkpJQR].[qualName], [lkpJQR].[coDBname] FROM lkpJQR; SELECT [lkpJobQual].[JobQual], [lkpJobQual].[Description] FROM lkpJobQual ORDER BY...

Yes. Both columns are bound.

I am trying to create a field in access that will store multiple fields form a lookup table. When I go to select the options a "0" shows up at the end of the list and "No" shows up in the other field of the same type. Does anyone know why this is and how I can get rid of it? I have looked at the...

Does anyone know of a way to compare the data between a current version of your database to a backup of that same database?

Is there a function that will return a boolean value to check to see if one record exists in a joined table? For example: In one table you have a list of customers and their respective customer IDs: customerID - PK customerName customerAddress etc.... In another table you have: orderID - PK...