Search results for query: *

Is there anyway that i can store a calculated value into the table? What do you mean in your last reply? Thanks.

I have a table with the following fields: customerID, First Name, Last Name, Zip code, # of seniors, adults, children, payment (cash, credit card, check) and yes/no fields: paid, reservations. The prices are not in the table. I just want the total price in the table, yes I am trying to store a...

Hi I am building a reservations program with ticket sales. I have fields such as "adults", "seniors", children. These are also textboxes on a single form. Right next to these I have a textbox for each of them that shows the result of the textboxes times by the price. Then to add all the prices...

Hey Sorry I didn't think of it, all i did was do a "on lost focus" on the text box and the wrote this code: If txtbox.text = "" Then txtbox.text = 0 End If

Hi, I am creating a form and I need it so when you leave a field, it automatically puts a zero in there. I have tried to do this with properties of the textbox "Default Value is 0" I have also put the default value to 0 in the table but when I leave the textbox blank it's just blank, A zero does...

I have solved the problem, thanks

Thanks, Works Great PHV

SELECT Sum([Seniors]+[Adults]+[Children]+[Family Special]+[Family Extra]+[Comps]+[Group Special]) AS Expr1 FROM Customers GROUP BY Customers.[Train Date], Customers.[Train Time], Customers.Reservations HAVING (((Customers.[Train Date])=Date()) AND ((Customers.[Train...

Sorry Typo* The data type is Date/Time with a medium time as the format: (EX: 5:45). Much Appreciated

The data type is Date/Time with a medium time as a "medium format": (EX: 5:45). Much Appreciated

Hey I copied the TimeValue(Int((Time+#00:59:59#)*24) & ":00:00") into my query under my "Train Time" field so i would look up all the times for the next hour and this is what i get when i try to run it. "Data Type Mismatch in criteria expression" Any ideas? Please Help. Much Appreciated.

Hi, this database that I am making is for a train station that has runs on the hour. What I want is the code to make the current time (Time()) to be rounded to the next hour. Example: the time is 9:04, I need it to be rounded to 10:00. I need this so I can use it in queries so I dont have to...

Hey Baltman, I copied and pasted into the MySQL view of the query and this error comes up "Expected DELETE, INSERT, PROCEDURE, SELECT, OR UPDATE and then it points to nNextHour in this statement: nNextHour=1+MOD(HOUR(DTOT(DATE())+CEILING(SECONDS()/3600)*3600),24)

SELECT Sum([Seniors]+[Adults]+[Children]+[Family Special]+[Family Extra]+[Comps]+[Group Special]) AS Expr1 FROM Customers GROUP BY Customers.[Train Date], Customers.[Train Time], Customers.Reservations HAVING (((Customers.[Train Date])=Date()) AND ((Customers.[Train Time])=Time()) AND...

Please explain to me EXACTLY where I would put it. Thanks

Sorry guys, but I am a stupid beginner. Where would I put this code? I don't know where I would put this code. I already tried some places but didn't work. Thanks.

Hi, this database that I am making is for a train station that has runs on the hour. What I want is the code to make the current time (Time()) to be rounded to the next hour. Example: the time is 9:04, I need it to be rounded to 10:00. I need this so I can use it in queries so I dont have to...

Ok, I have a more complicated situation. I have one table with fields: CustomerID, Train Date, Train Time, First Name, Last Name, Zip Code, Adult Tickets, Children Tickets, Senior Tickets, Payment (list box cash, check, CC), Reservations (yes/no). I need the text box to count up all the...

Hi, is there any way i can add up the yes values in a table and view them in a textbox/label in a form. For example, My table contains the field for reservations. The values are yes/no, but on the same form that I am making the reservations, I need to know how many reservations there are. so I...

Would I use this in a query?