Search results

Can you post the query? I am guessing you may need subqueries, but wont' know until I see the post.

I don't have a problem either. Can you post the whole query?

The main purpose of an Excel Spreadsheet is, well, to work as a spreadsheet. They are far quicker for analysts to quickly create different scenarios with a base amount of data, to quickly create calculations which involve relative locations to other cells, and it has a much more robust...

Here's The Correct Query Sorry, first query I posted was the original setup and not the finished one. Here is the finished query. I used "tblCheck" as the name of the table, otherwise kept your fieldnames. Note the use of three subqueries and the use of an alias on the main query. SELECT...

give me a sec, sorry

Since all your data seems to be present, I would go ahead and be safe and create new tables based with the same fields as the old tables. Do the following: 1. Open a new table in design view. Size it to fit half the screen, vertically. 2. Open the corrupted table in design view. Size it to...

Check out the AfterUpdate help file for the listbox. It works pretty much the same for the combo box, as well.

You have a table that is a prime candidate for normalization. Instead of horizontal expansion regarding survey answers, consider creating an "answer table". A query linking the answer table to the contact table is much easier to create. In addition, changing the fields from text fields to...

Oops, sorry. I have given this type of help to several other people that I forgot that you had multiple controls to format. My bad. First, get the name of the control that contains the date you want to compare. NOT the field, but the name of the control. By the way, this is a good time to...

I'm not exactly clear what you want. I understand you have a combo box on the main form, call it ComboBoxA. You want to open up a subform. Once the user picks a record on the subform, you want a value to appear in a combobox on the main form. The question is: is it ComboBoxA, or another...

Only difference between a memo field and a text field, it cannot be indexed for sorting. Make sure you have a primary key associated with the memo field, preferably an autonumber.

Are you ADDING or UPDATING a current record?

Pat, since it's a date field it can only be null or a number (date format). In any case, Zurvy, you can adjust this expression to use in your query. The pertinent Iif statement is in red: "UPDATE tblShipments SET tblShipments.ShipDate = Iif (IsDate([DateField]),[DateField],Null) WHERE...

If you have the "Northwind" database on your system, check out the form "Categories", which uses a subform called "ProductList". That should give you exactly the information you need. If you don't have the Northwind database, you should be able to google it and get it somewhere. Make sure...

Since the teams are already associated with a division and, through the division db, a league, you don't have to replicate those attributes. Unfortunately, though, I can't really give you anything I have because I have serveral more factors to consider (players can play for more than one team...

Basically, if you are looking at obtaining one unit of data from each single recordset, then the domain function DLookup for each item should suffice. When you start using the domain functions for more than one piece of data from the same record, or when using them when queries would be more...

I have a sports betting database I'm trying to gin up interest in Vegas, so I not only have to deal with baseball, but virtually every other sport that can be wagered on. As such, I had to devise the best database structure for each league, division, or conference; not just for baseball but for...

5 days/week x 8 hours/day x 50$/hour = kaching! 1 pint of beer

Instead of .Find User_Stats_an = vbarecord Try .Find "User_Stats_an ='" & vbarecord & "'" Since vbarecord is a string object (as to your function declaration) you need to put the string quotes around the variable. The whole .Find statement must be in the form of a string as well.

A form can only have one recordsource. So you can't bind two tables to the same form. However, you can (and you should) create a query that obtains the data from multiple tables and creates the records you need to display on the form. Once you save the query, you can then use that as the...