Search results

You have a database that is not normalized. Although the query question you ask is actually simple to answer, your table has repeating fields (question numbers) that can actually be made eaier with a table normalization process. In fact, let me give you the answer for your current table...

I know you said you "really need ten members in each record." But I don't see any way of solving your problem without some normalization. Can you zip your db and attach it to a message? I would bet dollars to donuts that you have a table normalization problem.

First of all, make sure your text boxes which contain the data are named differently than the data itself. If you created the form with a wizard, bound text boxes tend to have the same name as the data they house (which, incidentally, is VERY VERY VERY annoying, Microsoft!!). Therefore if you...

What are the names of the subform controls on the main form?

I assume your text boxes are bound to underlying queries or expressions based on table values. Check the underlying queries first, then the field controls.

Here is a query I just cooked up. The key is to create an alias table and subquery the actual table three times, once for each field. SELECT DISTINCT (SELECT Count(tblTest.FieldOne) AS CountOfFieldOne FROM tblTest GROUP BY tblTest.FieldOne HAVING (((tblTest.FieldOne)="hcapp"));) + (SELECT...

Why don't you either send the database as a zip, or if you have a text or word document with the proper format, send that as an attachment? I think I have some suggestions, but I do need to get a clearer picture of your existing entity structure. Thanks.

I really don't see anything more complicated than this statement. Assuming your checkbox is named WarehouseFlag, WarehouseFlag.Value = 0 If you have actions associated with clicking the checkbox itself (not just providing a flag, but actually performing an operation) then you can also add...

You can tighten up the code into this single line. This will give the date of the next Monday and return the same date if the date is already Monday. No interval variable is necessary, and you can place this line right into a query or form control without using VBA or macros. Me.Startdate = _...

Take a look at the DateSerial function.

One note about the TOP n function: If you base a return on a non-unique field, you may not necessarily return all the data you want. For instance, if you have a field with values of 1,2,2,3,3,3,3,3,4,5,6,7, and request the Top 5 records (sorted in order), you will only return the first two...

In the Left Join clauses, you need to prioritize join structures with parantheses. Change the FROM clause you have highlighted to the following: FROM ((Tariffs LEFT JOIN Schedules ON Tariffs.ScheduleID = Schedules.ScheduleID) LEFT JOIN AdviceLetters ON Tariffs.ALID = AdviceLetters.ALID) LEFT...

Rather than attempt to answer your question, as I don't have all the data, let me prepare this more correct method of filling out your combobox. I am wondering how your combo box properties are set up. In addition, do you have a sorting arrangement you want shown? I mean, alphabetical by...

What you want to do is have the query to identify field names, then group the field names according to their first letter, then to perform aggregate mathematical operations on data within the fields. Off the top of my head, I can't imagine any queries that you can make without accessing the...

I need more information than what you posted. What tables do you have? What are the relationships between the tables? In addition, if you have no data in any one of the tables, it will return no records. If you can, zip the database file and post it as an attachment.

Not sure if this is exactly what you need, but take a look at the actual query. SELECT tblCashier.Cashier, Count(tblCashier.SaleDate) AS CountOfSaleDate FROM tblCashier WHERE (((tblCashier.SaleDate)>=[Start Date] And (tblCashier.SaleDate)<=[Stop Date])) GROUP BY tblCashier.Cashier ORDER BY...

The Iif function will always return BOTH calculations and display the calculation that satisfies the expression desired. Therefore, since "NA" is ALWAYS returned, even if not used, any number formatting on the field (including dates and percentages) revert to General. Rather than formatting...

First, let's create the formula. Since you are looking for all dates more than a month old, I assume the following is correct: For July 9 2005, you are looking at all dates from June 9 and before. Therefore, the date would be caluclated as follows: DateSerial(Year(Now), Month(Now)-1...

Try inserting DISTINCT in your SELECT statement. This will return only non-duplicative records.

I'd go so far as to say that I don't even think he needs to add fields. If he has a consistant algorythym, then all he needs is to query one field with the formula to produce the result. Let's say he has a field called "Volume" with the value in the field. A query would be created called...