Search results

Looking at the tables created by the Wizard, tblEmpInfo is a major player: one record per employee (but I would make the Cell No primary key) assuming it is unique to an employee. Then if an EE had 2 phones, he'd receive two records and two billings. It seems this table should also contain a...

You're welcome, hope it helps. Season's Greetings!

Speaking only for myself, yes, a mockup was what I had in mind. So that I can see what data would normally be recorded on a frequent basis. I always start by preparing the tables, but intuitively I know what the transaction is in my mind. From my lack of knowledge here, I am guessing that you...

Can you not use a Custom Format for the ID field in the table? A-1 becomes A-10 and eventually A-10000 without loss of sortability.

If nothing else, this demonstrates the huge difference between Excel and Access. Data Types in the various tables, for example, are Text instead of logical. Field Names have spaces between words and are too lengthy. You need a starting point...a form that represents a transaction. The Excel...

So it appears to help using that downloaded file would be illegal, so I've put together a sample that might help the poster.

This thread is still open, in case others are interested. I am unable to open the link in the first post. It downloads a compressed file 10222096 (a Cab file) which extracts as an info file and Access Template file. While 2007 compatibility allows me to open (into Access 2002 SR3) an mdb file...

Kvar: Welcome back. We kept ourselves amused during your absence. I was curious why (since you have three fields of values in the AgentCallDatatbl) you don't include in that table the QAScore and the ADHPercent fields. I'm sure there's a good reason, but it would simplify your querying.

Super! I never use SQL unless I have to, so I missed that one. Still, I've left the poster with a half-answered problem.

If you stick with Append queries: First thing, your Primary Key should be turned off temporarily. Each Update Query would follow the pattern of creating a field called ServiceDate: (ServiceDate2) and would have criteria of Is Not Null. The other fields would be Keyfield, and Equipment. After...

I can get this far... Of course, it meant adding four blank fields to other tables to make them consistent and including those blank fields in the three queries.

Just thinking out loud, but could you run three queries (not Total type) each to extract those records from a Datatable that are the previous month's records; then combine them with a union query (or build a table from them); and finally perform an Avg query from the result, tossing in the...

I assume that the criteria limits the output to those Agents having a previous month's record in each table. Each failure to match reduces the output by that one Agent, regardless if it has records in two of the other tables. Right?

"A very confused Brian": Pari has yet to chime in, but he hasn't indicated he's changing his objective. He's familiar with Between and I think he's wondering why there isn't a function that calculates the way we think: i.e., How many months Between January and March? So I think he's trying to...

Pari: I'm curious why you would want to avoid this particular solution. You could create a new expression through code than combines the functions that exist in Excel for example, like RoundUp; but why?

And, in case you hadn't guessed, that makes it a calculated field instead of criteria.

Just when I thought we had it, you've muddied the waters again: I posited that you wanted the total days between A and B dates. Now it sounds like you want the total months (inclusive) as a whole number. Thus from 29 Nov to 3 Dec would be 2 ?

Sarma: Assuming you mean you have a single table with StudentName, Exam1, Exam2, etc., then the query would include all those fields and a Calculated field: TotalExams: Nz([Exam1],0)+Nz([Exam2],0)+Nz([Exam3],0) keep adding for each field to be included. Nz(field,0) stands for convert the...

Brian: Based on what Pari has said so far, he appears to want the whole number of days lapsed from Issue Date to Expiry Date. If this is insurance, however, our policies in Canada expire at 12:01 midnight, so don't include the last date. Pari should likely confirm, however.

You are likely using 2007 and I use 2002 SR3 with XP. Even if I download the MS file, it might be better if worked on within v 2007. I'll gladly help you without charge if you want to bring me a copy on either a laptop or flash drive. I do have 2007 compatibility. You can email me. Moderator...