Search results

piles of pounds

The intention is to create one Query (the Dummy Query) and makeit whatever you need it to be. Sorry for any confusion.

Is the VALUES section of the INSERT Query correct? It looks like you are trying to store a DOUBLE in a Date Field and I am not sure what the result would be. tmpDB.Execute "INSERT INTO [Usage Log]([NT ID], loginDate) VALUES(" & Chr(34) & getWinUser() & Chr(34) & ", " & CDbl(Now) & ")"

One way to go about this is to use VBA to create a dynamic SQL Query that selects the required elements, and then update a dummy Query and modify its SQL Property to contain the dynamic Query. Something like the following would fit the bill. Of course you need to fill in all the missing parts...

Actually, I believe that he did, but I think he had a Type-o. Below is an updated version of the Query that had your latest mod in it. I believe that the Ref was intended to be Rev, and that LastRev is an Alias label for the returned value of the Max() Function. -- Rookie SELECT [Ref]...

I am not an expert in this area, but you can check the following Link to see whether other experts that have encountered similar issues can be of help to you. -- Rookie...

As namliam pointed out, a union Query must have the same number of Fields in each section, and each Field must be the same type as the corresponding Field in each other section. One more thing to consider is that if the Fields have different Names in the Queries, the Names used will be the...

It appears as if toppock (or at least the user) has uncovered a possible Design shortcoming. While your approach would most likely eliminate the problem that occurred, it would also have the effect of covering it up, and the possibility that the problem could return would remain. toppock...

I agree with Cronk that the Query you showed would provide the same list of Questions each time. It also is not the way that you want to use a Union Query. Instead, it would be better to select each required Fields by name. You could also create Aliases for the Queries to use in case any...

whatever they wanted

stuffed with old

cannister made from

If that is the case, then I believe that the Nz() Function could work if you set the conversion value to 0. -- Rookie

Does the Primary Key need to be one of your Data Fields? Consider adding a new Field with Type AutoNumber to the Table and making it the Primary Key. (I would try to put it at the beginning, but I do not think it matters). Since your Data Fields are not keys, you would be able to duplicate...

Consider giving your If() Statement more directions as to how to process the conditions by adding "(" and ")" as required. On possible suggestion might look like the following: If ((Me.Program_Type.Value = "(1) 45 Minute Formal") And _ (Me.Cost_Category = "Full Price") And _...

Pat has a great point here, but you CAN avoid the conflict by not using the "*", and identifying each of the Fields in the Select Statement instead. You could assign an Alias (I like to use Aliases that are meaningful to me) to any Field that needs one. This should also get rid of your ORDER...

That should be easy to fix by adding two new Tables, but the Queries ad the coding will need to be modified to accomplish it. One way would look like the following. OLD FORMAT: tblUserNetworks FK to UserID Network1 . { More Networks } . Network 173 NEW FORMAT: tblNetworks NetworkID...

Question: Are you stating that there is a Row for each user that contains over 170 Fields representing Networks in the Table, or are there repeating Groups of Fields in the Table representing the Networks? The sample layout does not show enough of the picture for me to provide a proper...

While I cannot speak for its authorative value, this Link on the subject seems like it is interesting. http://www.press.umich.edu/pdf/9780472032419-unit2.pdf

Question: Are so many Fields required, or does the Table have repeating Field Values in a format similar to the following: Month1Value1 Month1Value2 Month1Value3 Month2Value1 Month2Value2 Month2Value3 . .(8 More Months) . Month11Value1 Month11Value2 Month11Value3 Month12Value1 Month12Value2...