Search results

Ok...heres what I'm trying to do... I've set up two queries, one to create all the null values. The other to search based off the form. In criteria for [txtyear] to change fldYear I have: [txtyear] = Nz("[txtyear]","[frmSearch]","Null") This is returning as containing the wrong number of...

Thank you for your quick replies. It's still early in the day here and my brain isn't working at anywhere peak performance right now so these concepts are still a little fuzzy to me. I think I understand the concept of NZ() but I do not understand how to make it work for my problem, same with...

Ok heres my problem, I'm building a search program that allows for multiple fields to be searched in one go. So I have a big query connected to a form with form objects associated to each field of the query... For example: There is a list-box for Job types: Road Reconstruction, Sanitary, etc...

This database is primarily for an inventory of road work (like job, employee's hours, and inventory used) I doubt that there will be multiple shipments of the same type of goods on the same day, most of the items worked with are salt/sand and diesel, I just need to be able to keep an approximate...

I'm wondering, what if you separate out the inventory by date, so that each set of 'bought' inventory is tagged to a date, and then set up the system so that the 'oldest' date for that type of item is removed first? Obviously 'lot' would be separated in a table by date instead of just by type...

I'm actually pretty new with this, but I'm a quick learner and I'm not eager to let my boss down, I'm going to read up on how to do this some more and will probably have some more questions later in the week as I'm going to avoid this part for a little while to get everything else in working...

I discussed this with my boss and he said he would like me to record quantities/prices based on the FIFO method... I have no idea how to go about doing this. My plan was to store quantity values with price values, but if there are more than one price value, how am I to set up a table to reflect...

Hmm, I probably need to provide more information. I have an 'employee wages' section that should only be changed by those with administrative control, essentially there are a set of forms that can be opened by accessing my 'admin' form though a password, I want to be able to protect the...

I have used basic code that allows me to ask for a password to be input in order to enter a form from another form, but you can still access the form and the table info from the database menu, how can i put a password on to the form and table in question so that it cannot be accessed in the...

Thanks for the advice Dave, I'll have to set up a meeting with my supervisor and see how he'd like to proceed. I wasn't even thinking of it in terms of final accounting measures so your bringing this to my attention was very important.

I am trying to build a database that includes inventory information. What I am trying to do is have a way of storing a base (yearly or quarterly) inventory and then every time a job uses material it will be recorded and a search of inventory can produce inventory used and/or current remaining...

Ok wow, that helped a lot thank you! I have one last question about totals. I need to create one more from in which I can show the total prices for all jobs by month (which I have managed to create using your information) BUT at the end I need to separate the prices in to two groups. One...

Hmm what I said wasn't clear at all. I have set up a Total Textbox, added it to the Page Footer, In Data I used Control Source: Price, and Running Sum: Over All, it only gives me the last piece of data though.

Thank you for your answer. I understand most of this other than the 'grouping footer' and the sum part. How do I create a 'grouping footer'? And How do I create a sum in it? Thanks again, A

Hi there, I have 2 reports that are pretty much identical(in that they both contain job type, hours, price, year, month and week) I was wondering if it was possible to find a way to be able to calculate price totals based on month and year. The queries calculate the prices of each job based on...

I have a system in which i have 2 tables. "tblCost" which has 2 fields (truck and cost/hr) and "tblTruckvalues" which has multiple fields (the important ones here are truck, year, month, job, hours spent). My 2 tables have a relationship along 'truck' I have a query, 'qryPrice' that has an...

Wow, that will make my life, much easier. I'm going to recreate this database that way. Thank you so much for you help! I anticipate having more questions in the near future, but until then, I'd just like to say thanks again for all your help Twoplustwo.

This solution makes sense for coming up with a cost value, my problem is I'm trying to associate each text value in my 'job' list menu with a numeric hourly value for the job (so that whoever is inputting the type of job is not necessarily aware of it's hourly cost) how would I be able to work...

Thanks for taking the time to look at my problem. I hope this explains what I'm trying to do a bit better. Essentially, I'm trying to get a weekly cost value for each set of actions IE. If truck1 plows snow for 10 hours in a week at $22 an hour, i'd like to be able to access the price of $220...

1 update, I accidentally changed JobHour to JobHours in this form, I have fixed that, it is not the problem. Thanks again.