Search results

THANKS it works...jnh

Sorry that does not appear to work. The query resets to the original coding which is actually is the same (as detailed below) but which does NOT test for 1st 3 characters being DMV. Please note that this Select statement is one of about 10+ and they all give proper replies but I have to check...

Hi, Trying to SUM all records where first 3 characters of Company = DMV. Have tried all kinds of () but always get the Enter Parameter... prompt. What am I missing on query? DMV: Sum((IIf([left$(Company,3)]="DMV",[AMOUNT],Null))) Your help is greatly appreciated. A Healthy and Happy 2016...

Trust this is what are you looking for.... SELECT Left([2014 Spring Tournament],1) AS PlayType, [tbl_2014 Roster].[Last Name], [tbl_2014 Roster].[First Name], 0 AS [Game 1], 0*1 AS [Game 2], 0*1 AS [Game 3], 0*1 AS [Game 4] INTO [tbl_Tournament Enter Score] FROM [tbl_2014 Roster] WHERE...

NOT a SQL - just a simple make table query with several fields taken from another table and new fields (Not found anywhere else) added via: Score1: 0 or Score2: 0*1 and so on. Given above example the Score1 (and Score2) field in new table will be numeric type but table shows a 0 in...

It is just a simple Make table query: Score1: 0 Where Score1 is a NEW field Using above I get a numeric field in my new table but value is preset to 0.

Hi, Have a Make table query that needs to create (add) several new fields where each field must be numeric design. Have tried: Score1: Not Null - does not seem to work (results in a Binary field) Score1: 0 - which does give me the numeric field designation but every field in table contains a...

Hi, Have 2 tables: ...TableA: 1 indexed field "Name" and many data fields in ~ 1000 records ...TableB: 1 indexed field "Name" and 2 data fields (DataB1 and DataB2) in about ~ 50 records Tables currently have NO relationship set. Want to add TableB data fields to TableA if Name are...

Action: User keys data into a Form Control which triggers a VBA event procedure call. The VBA event uses value of user input to perform several calculations. Result of each calculation in then placed into proper control (me.NumA = result1 me.NumB = result2....) during the VBA call. Problem...

Poor explanation on my part: It was my plan to use a query to call the VBA (function) procedure but just don’t know how/where to place instructions needed to activate proper VBA call. The query will have 2 Major functions (please note that ALL fields listed below are already in table)...

Have a table (several hundred entries) which must be updated weekly using VBA code. I know how to write the actual VBA code (for each record) but I do not know how/where/what is necessary to open the table, read each record seq and update based on VBA code (function call return value) and to...

How steps/clicks are needed to indicate a 'Thank You' ?

Must be getting late - Don't seem to find There's the Scales at the top of the helper's post

There are tied to a Control Source (Table).

The Color fix is in - Thank you Believe I had done what you suggested (see sub routine below) but it will not clear keyed data (must be doing something wrong). Also how do I OFFICIALLY express my thanks ? Private Sub Score2H_BeforeUpdate(Cancel As Integer) If Val(Score2H) > 11 Then...

Pretty new at this game and still have many ??? but for right now can anybody help me with: ...Have disabled a couple of fields in a form. Would like to change the Background color to something else instead of that 'Grey" given ...When Validating a field (via a sub routine) I would like to...

Sorry but no WSOP for me - that is a totally different class - The ULTIMATE

LV is Entertainment - starting with the various huge casinos, lights, shows, gambling, nightlife, pool parties and ......... LV is probably like no other city in the world. We live about 20 min from strip and we love it here (retired but still have a desire to learn new programming - like...

There are: 200+/- Teams (each Team identified by a TeamID) - table is loaded 15 Weeks per season (1-15) 5 PlayDays (Mon,Tue...Fri) 3 PlayTimes for any given PlayDay (AM/MidDay/PM) 6 PlayingFields (1-6) Total: Up to 18 games per PlayDay BUT there are usually less games on any given day (due to...

Hi, Have a table with 18 fields and based on content of a given field I might have to create a new output record. This means that it could be possible that the need for 18 new records for every input record may exist. All new records must go into the same new table. Any suggestions, Thanks...jnh