Search results

No it definitely isn't about copying values from previous record. It's about having controls with repeated values in the forms header (once), and all other values of the records in the detail section (or something like that). Thanks for your answer though.

Hi everyone, long time no see, trying to avoid bothering you all beautiful people with silly questions. Well, I got a tblTransactions, that holds records of everyday transactions on multiple accounts, and bears fields like TransactionID (PK), TransactionDate, AccountID, TransactionType...

Glad you figured it out! This might help in seeing things in a better way --> http://msdn.microsoft.com/en-us/library/office/aa662176(v=office.11).aspx

Remove tblMembers from the second query. There isn't a reason for it to be there. In attached copy there's only one record so what you're describing isn't happening. (Happy birthday by the way). All these though, are normalization problems and I'm afraid you're gonna get a lot of these as you...

Something like : If Me.FieldA = "Yes" Then Me.FieldB.Enabled = True End If HTH

Try something: Change this Tot: DCount("[EmployeeID]","tblMedicals","[EmployeeID]='" & [EmployeeID] & "' And [OnDate]<=#" & [OnDate] & "#") to that Tot: DCount("[EmployeeID]","tblMedicals","[EmployeeID]='" & [EmployeeID] & "' And [OnDate]<=#" & Format([OnDate];"yyyy\/mm\/dd") & "#")

What makes viewing a 130-field query easier than viewing a 130-control form? Anyway, there's no such thing as a modal query (as far as I know - maybe someone else has a different idea).

Why don't you create a form based on that query?

You should first design the total_queries for each one of your six, and then create a union query to combine all six total_queries.

I've been struggling with an issue like this , all day long. This is what I've to finally come to a solution. Completely Deleted Query. Compact and Repair. Re-created query with the least possible fields. Compact and Repair. It finally worked. Make sure fields on which you apply the criteria...

This would help : http://www.youtube.com/watch?v=60o0hRUfBHs

It doesn't make sense, it works fine on my copy. That's why you have to plan first, design later. Having households (Families) as members of the community, and people (Persons) as members of households, would do your job as it seems. Relationship between households doesn't seem to be your...

Like I said before, that happens because your filter is a date and you apply it on a field that isn't (no matter how it looks - DateSerial result isn't a date although it looks like one). You're gonna have to redesign your database. If you're willing to do so, (I'm afraid you have no other...

With the information given, and more I could imagine, the attached schema should do the job. On your data entry form, lookup (combobox) controls will help you enter all data needed. But, You have to define the information you have, how it is related, and the information you need as an output...

I think you'll have to fix it in your first query using CDate function and then pass it to your second query. (I didn't try it). At least Members table has normalization issues and will cause you trouble for sure. (8 Fields for children? What happens if someone has 9?)

That's because you apply date criteria on a string field.

The way you have your relationships you'd have to add your Family table too in the query. P.S. Your database needs serious normalization

Give your Sum([Sales]) a name (alias) like TotalSales:Sum([Sales]). Save your query and create another one based on this, where columns are not calculated any more, they are plain numbers. There you can perform your division. If you really want to calculate sales percentage of total you should...

I'm afraid you got it all wrong. There is no 'very last row' in a query. Totals appear in specified columns. Take a look here --> http://www.599cd.com/tips/access/aggregate-query/

What arnelgp suggests is that you you keep "Group by" in the Totals Row of your query design, in all columns, except column 'Sales' and 'Sales Goal' where you use 'Expression'.