Recent content by klallen810

Yes, that definately helps. I will work on normalizing and implementing the query as stated above and if I have any further questions I will let you know. Thank you!!

So for the EstCost portion, would I need to name every field that I have an estimated cost for? This is what I am trying to avoid since there are so many fields. Each port call has its own unique Vessel ID. If I could do something like what you said, but without having to name each field that...

Hi, I am trying to find the best way to compare estimated expenses to actual expenses in Access. I am working with vessel and port call information, so each port call has a series of costs associated with it. I have two tables, each with multiple fields (around 100). Each of the fields...

Definitely works, Thanks!!

This may be a silly question, but I cannot find a place on the site where you can easily go to your past threads. My company has strange web access so this might be the issue, but can someone tell me where i should be able to find this? Thanks! Kendra

Yes. For example, for each event costs might incur such as linens, set up fee, catering, glasswear, etc. Each has a specific cost tied to it and goes into a different cost code for accounting purposes. I would like to analyze these costs to see which cost contains our largest variance as well...

I have a database with two tables, one for the amount that was estimated in each cost section, and one for the actual amount billed for each cost section. The tables have the same number of fields, all with the same names. They can be linked together with event ID. Each table has over 100...

Works perfectly. Thanks!

Hello, I am trying to filter a form that is based on a query by multiple values contained in checkboxes on another form. I don't have enough room to put all of the checkboxes on the first form so I created a second one. The first form is a list of items that are due today, there are...

Hello, I am working on a nutrition tracking database and would like to have a form that updates my “Goal Weight” Table, so I don’t have to type in every day, and every number. Basically, I have a form and a subform. The subform is a datasheet from the GoalWeight Table. It is currently...

Thanks!* That blog will certainly help.* I do believe I will have to re-format the db a little bit though.* I currently have the ingredients in a recipe table in a field listed as: Apple, 1 whole Vinegar, 1 cup Olive Oil, 1 tbsp Etc.* I believe I will need to create an ingredients table and have...

I am currently working on a nutrition/exercise/weight tracker database.* I am trying to build a form where I can enter measurements and then have them update a pivot chart containing a line graph to show my progress.* I currently have the date in the form header, the text box entries for...

No, but I need different instances to see how much of the particular ingredient I need. I just need them in alphabetical order, not alphabetical by recipe but all of them listed in alphabetical order

Thank you for your response but it did not work. I tried to use a concatenate stmnt but I could not get that to work either

Hello, * I am currently designing a database to keep track of my nutrition and exercise.* Included in the nutrition portion I am adding recipe’s and planning meals a week ahead.* The purpose of this is to put the list of ingredients needed over the next week into a shopping list report.* I did...