Search results

I don't see a safe way to accomplish it without the first Make Table Query having at least all the fields from the existing table that has the most fields. e.g., take one table, add the Make field, insert the value of that field for the first table's records (e.g., Ford). Then use the Make-Table...

In case you haven't worked with this approach, see the two tables attached. First, you would have to link them (as you mentioned), then look at the two records in the automatically displayed form. Click the Update command box and observe the change in the values of the subform.

Have you considered an update query that selects those fields from Table1 and updates Table2 that is linked?

If, as I suspect, there is no reason for security, a password might be overkill. An unbound form with 12 command buttons--one for each Agent--might suffice. By setting the Tools\Startup\Display Form to the command form, the input form would be opened from such a command and its default value set...

I'm assuming you are all inputting at one location rather than remote. If there are just a dozen agents, you could open the form and SaveAs a different name, eleven times, giving each copy a different Default Value in the Form Data Properties (of an agent's name). Each could open his own...

Try downloading this attachment.

The only missing info is the PC-BB handling, but you can get it sorted. At the moment they are included in the Final Totals. Not all records are entered, and you would have over a hundred per day. Here's a picture of the Relationships, fieldnames, and input form used. And the reworked query...

Could you add another field called Absent (a Yes/No) field. The Mark presumably would be Zero. The Criteria of Yes in the Absent field can be used to force a text entry to replace the value. This way, your Marks can be a Number field.

I'll have to make the changes that you've given (subtotalling the NoOppts and Oppt) before doing so. In Canada it's after 10pm so it'll be tomorrow, sorry.

Here's a quick version using three tables: tblAGENTS, tblSOURCE, and tblCALLSmade. One form to input data. Three queries: qrySummary (all entries input), qrySummaryTTL (totals by rep), and qryTotals (final totals by Source). I only input 14 records for the 17th Dec. and I didn't format the date...

I've looked at the pics and am attempting to establish tables. Couple of questions: Obviously the meanings of the columns OPPT and NO OPPT are immaterial but TotalCallRec is a total field and need not be in the table. Is there a connection between the "NoOpt" and any other columns? Is it a...

Instead of importing from "New Database Query", use the "Import Data" choice. It worked for me even when I placed the result in a group of cells that had been pre-formatted to Number. By the way, in this way you don't have to reenter the query formula...it's already in the query you choose from...

Reading between the lines, you are IMPORTING to EXCEL from ACCESS. I based it on EXPORTING from ACCESS to EXCEL. That assumes then that your are not allowing Access to dictate the field formats from its own field data types. Am I on the right track?

I just tried it in a Select Query (even included the parentheses and used the reserved word "Time" as the calculated field) and it worked fine. I then used Analyze with Excel and got the same result. I'm using Access 2000 SR3. How did you do the export? I even tried different Format for the two...

shahid: I'm not sure whether you mean both values such as 1795 and text such as A or B in separate records; or a combination of both, such as A1795. However, a text field allows both numerals and letters. The problem comes when you wish to either sort or search within those records. Thus...

Adam: He's not getting 0 as the Count because there are no records being counted, so the function doesn't happen. There would have to be a previous verification that there were records to count...like a select query without totalling.

Can you supply the Expression/formula you are using that causes the error message please. Also, you understand that the result of the formula is what is being exported. Is it a date, a number, a text value that you expect?

Whoops! Forget that question, it works even in 2002.

This is a 2007 function. Are you using 2007 or an earlier version of Access?

I'm sure there's an easier way, but to start the ball rolling: People table has personal data & an IDNo (primary). Published table has IDNo (foreign key), PubPhone, Type, & PubFax UnpublishedFax Table has UFaxIDNo (Primary), IDNo (foreign), UnpubFaxNo UnpublishedPhone Table has no primary key...