Recent content by brianjay

Remou and TheAceMan1 THANK YOU. With some reading and setting up the proper variables; I was able to get the querys to appear in the proper forms Again, I'm sorry for the miscommunication - but THANK YOU again brianjay

I apologize for the confusion and the bad etiquette that I've shown. The 2 of you have been VERY helpfull; but I don't seem to understand the directions that I get from programmers. i know that I have a lot to learn so PLEASE bear with me. Let me try to start over with this with the real info...

i placed the question in 3 areas hoping to get an answer. I don't always get answers when placing in 1 forum. I'm a beginer and Remou's answer although good is a bit confusing for me. Your answer has shed some light on his though. I'm still lost, but i am getting there.

I believe that, that is what I want to do. I want it so that the sequence is as follows: 1) click the "T" button on the "switchboard" 2) "switchboard" closes, "Main Form" opens" (this part is done). 3) "Main form" opens with the title "T" and the appropriate logo showing (this part is done)...

I'm sure that this is simple; but I'm lost I have a form with 26 Cmd Buttons (Cmd_A - Cmd_Z). I also have 25 querys (Qry_A - Qry_Z); each calling up specific info. All of the buttons open the same form; but with different properities on it (color, text, logo, etc.). The form has 1 subform...

I'm stumped. I have a .txt file that has a list of info: First Name Last Name Address 1 Address 2 (if needed) City State Zip Code Expiration Date Type of License License Number Each record may be 8 or 9 fields wide depending on if a 2nd address is needed. I can import the data to 1 long field...

SUCCESS THANK YOU lespaul and everyone else

I rewrote the SQL query (made it cleaner) and it produces the correct totals for the individual fields, but I still can't figure out how to create a grand total based on these 3 fields. SELECT Sum(Tbl_Merchandise.Merch__FeeList) AS SumOfMerch__FeeList, Sum(Tbl_Merchandise.Merch__taxes) AS...

SELECT QrySum_FeeList.SumOfMerch__FeeList, QrySum_Taxes.SumOfMerch__Taxes, QrySum_Shipping.SumOfMerch__Shipping FROM QrySum_FeeList, QrySum_Taxes, QrySum_Shipping;

I have 3 querys: #1 = sum of all fees paid #2 = sum of all taxes paid #3 = sum of all shipping paid I also have 1 query that houses the 3 sums listed above. I can use "either" /"or". I need to create a 4th query or field to generate the sum of querys #1,2 & 3. I'm sure that this is very...

My Cisco 802 is running with a DHCP address. I'm trying to change the DHCP to a static IP. I have the IP, but I have no idea what telnet commands to use. I could modify and upload a file that I use for reference, but I don't know how to do that either (I'm A+ cert., but telnet dumb). 1) What...

To lupins46: The DB is a MySQL db somewhere in Texas (i'm in MD). I can't create a sql query with access because I can't connect to the db and the CR10 sql editor is VERY confusing to use. I believe that the db is wacky. To synapsevampire: It seems that the "not isnull" funtion worked great...

I have a database with a start date and an end date (neither are time stamps). I want to report only those items that "DO NOT" have an end date. How do I do it? Thanx, brianjay

I'm retriving data from a "MySQL" database into CR10. The data field contains an entered time (ex. 3:45pm). When I view the CR data the time appears as (ex. 12:00am). The data is being entered via a web site and I suspect that the server is configured weird. Is there anything outside the norm...

I'm retriving data from a "MySQL" database into CR10. The data field contains an entered time (ex. 3:45pm). When I view the CR data the time appears as (ex. 12:00am). The data is being entered via a web site and I suspect that the program is at fault. Is there anything outside the norm that I...