Search results

I got it figured out. I was putting the sum textbox in the page footer and it did not like it. Once I put it in the report footer it was working fine. ________ Bong

The following query I have totals for each facility. At the bottom of the report I would like a grand total of all of the facilities. I tried using the "running sum," but couldn't get it to work. Please help....Not for sure if there's a function I can use in the report, or if I have to do the...

thanks a ton.....exactly what I was looking for. Kacy ________ Montana marijuana dispensaries

Below I have a query that is the control source for my report. At the top of my report I would like to include the dates that were entered into the following query (Enter Start Date mm-dd-yy] AND [Enter End Date mm-dd-yy]). How can I get this to work where I can just take the inputed data from...

Thanks Pat, Got it working fine. I have three different queries b/c they are different sums, that I joined together by a fourth query and use the fourth query as my recordsource of my report. Not for sure if this is bad practice (the number of queries it takes), but it's working. Thanks a...

ok, your gonna kill me.......I've got the two queries written. Seperately they return what I want. However, not finding out how I can join these recordsets. Please help, I'm getting closer. Thanks, Kacy ________ Medical marijuana

I must be brain dead b/c I'm not following.... I'm not quite for sure if I explained myself clearly either. Here's my goal.... I want to find the number of units ordered, received, distributed for a time frame that the user enters. I then want to sum the total received minus the total...

Thanks for replying.....I looked in the help section and still having trouble figuring out how to use the subquery. Can you please help? Thanks, Kacy ________ Zx14 vs hayabusa

I have a query that does a recap on inventory for the time frame that the user enters. Basically it says how much was ordered, received and distributed and Qnty on Hand for the specified time frame. If you notice in my query I say "Sum(UNITS_RECEIVED)-Sum(Units_Distributed) AS QNTY_ON_HAND"...

Thanks. Kacy ________ HERBALAIRE VAPORIZER REVIEW

I have reports that users can view. They are requesting that there can be a way to search these reports. Like a find button. Is this anyway possible? Thanks in advance, Kacy ________ Anal

Thank you guys....can't wait to try this when I get back to work on Monday. Thanks Again! Kacy ________ Vaaapp Vaporizer

On my delete button of my form I was wondering if there was a way for users to cancel the delete macro if they accidentaly hit the delete button. Thanks in advance. Kacy ________ Medical marijuana

Never mind with the query comment....I've got it working. Thanks, Kacy ________ Avandia Heart Attack

I'm still having the problem of the UserName textbox not being updated into my table when they are updating a record. I'm now trying to write a query that will update the User_ID field into the table. Here the query that I have written and the error that it is generating. UPDATE APPOINTMENT...

If it's a new record it works fine....it is inserting the user name into the UserName field of the table Appointments. What I'm trying to get at is if somebody updates the appointment "Clicks Save" I would like for their User Name to be inserted into the UserName field of Appointments. Thanks...

GREAT!!! I'm getting closer....I've got the text box able to display the user name. The control source for the entire form is a query. When I leave the textbox "unbound" and use the =GetUserName() for the default ...it works. But when I save the record I would like for it to save to my...

Thanks for responding...... Rob - We're using Windows 2000, but use Novell for the log in. Mile-O-Phile - I tried the code you had posted on the other thread, but not for sure what to do after I've copied the code into the Module. I saw you said to make the DefaultValue of your table...

Not for sure how to ask this and I'm open to any suggestions.... I have an appointment scheduler...users can update, add or delete any appointments. The problem now is everyone is wondering, "well, you deleted/updated who." So I plan on implementing an Operator ID that when users click the...

not for sure if this would work....but how about defaulting your "ConsultHours" to '0'? Hopefully would perform the correct calculation with fields both being filled. HTH, Kacy ________ Handjob vid