Search results for query: *

Hey Steve, Without adding all the extra concenated fields, here is the monstrosity I cooked up with your help, to Display the Quantities: DisplayQuantity: IIf([PromoQuantity]=0,"",[PromoQuantity] & "-units, ") & IIf([YS]=1,"",[YS] & "-YS, ") &...

HI Steve101, Thanks for the info. I will have a go at it later tonite. My database is structured so that only information pertaining to a single product is in my table. Unfortunately I need to see the different sizes on order. I considered setting up a seperate table but it justs...

Hi, I have 10 fields in a table(Order Details). These fields are sizes of Clothing(YS, YM, M, L,etc.) In a query, how can I concenate it so that the results appear as (FIELD1#)-YS, (FIELD2#)-YM, (FIELD3#)-YL 10-YS, 8-YM, 6-YL and have it so that it only displays the...

Hi People, Here are my Forms -------------------------------- |CUSTOMERS | ORDERs | |(main) |(sub) | | | | | |___________ | |Order Details | | |(sub of orders) | |...

Hi, I have got the pop up to carry the value I need(thank you again). But I cannot get the OrderID value from the Orderdetails subform(continous) to populate with the OrderID from the main form. I am stumped ason1976 hope i'm not rambling

KornGeek My relationships are set up Customer(one) to (many)Orders(one) to (many)Order Details(one) to Product Details. So in my way of thinking, having a Customers Subform kind of ruins the chain. Could you elaborate? Trendsetter, I will attempt and reply? How would it work if the...

Actually, Trendsetter, alot of my query fields are expressions. Lot 2 I am designing this DB as a POS system, so the customers needs it setup up as too see the customers and the orders simultaneously. But that doesnt solve my conundrum of how to populate a box with the corresponding field from...

Have your DAte field in your table and add that too your query. Set the property to =now() when your salespeople enter the transaction it will autofill the current date and save that in the table and the query. And all your calculations will be on the query (which is just a dynamic table)

2 things--> I have 55 fields(i am considering adding more) in a query based on two tables. Could this be a problem? Secondly, my database has Tables- Customers, CUSTID(autonumber) Orders, ORDERID(autonumber) CUSTID Order Details, ORDERDETAILID(autonumber) ORDERID Product Details...

Create a query using the SALES table and add your expressions to that. Then base your form on the QUERY and your values will be saved. ason1976 hope i'm not rambling

I believe if you add an Initials field to your permit and inspection form(use the lookup wizard and on your form you will have a combo box), you can change the AUTOEXPAND property to yes. So If one inspectors initials are AAB and the next guys BBA, typing A or B will return the correct...

Have you thought about basing your form on a query instead of a table? I find it works better when using calculations doing it that way.

Here is another one (Freeware) Band Speed Balancer -It has a limiter http://bsb.net.ru/ maybe it helps, maybe it does not

K9Logic: Searching Google I found a demo product(retail 49.95) called Bandwidth Controller 0.04. Here's the link ---> http://bandwidthcontroller.com/index.html Hope it works for you ason1976