Recent content by HelenaT

Thanks for the quick reply. It's SQL server, yes, and I don't have access to the back end because the database resides on a server that belongs to a different group organizationally (I am school of medicine and the server is the hospital) and therefore I am not allowed to have access to the...

I am looking for advice on how to handle this data. I use a SQL database that is provided to our program for annual reporting. This database application has limited reporting capability and I do not have access to the back end data. I export reports from this database into Access, where I...

Thanks for the input. I will change to save the CardValue, not the calculated price. I am having some trouble understanding how I would do this June7 stated this as one way to save the current CardValue. 1. save unit price in effect at that time, not the calculated quantity x price - problem...

Thanks for the input. The reason I am saving the cost is that other parts of this database will store costs directly, and I want to use the same table design for pulling all the data together. Eventually there will be other data - taxi, housing, lab and medical. All of these will be...

Sorry arenlgp, but I don't see that the Cost field is updating. I see the change to the query, which I understand. The cost field still doesn't update when you change the Card Type on the form.

Hi - I've attached a dummy version of part of my database. The idea is that I have several different types of logs (gas, convenience and bus) that I am entering into this database. Each type of card has it's own cost, and that cost can change over time. I ultimately want to store FakeMRN...

Will do. Thanks theDBguy.

Hi - I am new here, so I am not sure what the best way to get comments/help on a design is. I am working on a project, and would like ideas, but I fear that the explanation will be paragraphs long. Please advise on how you want questions posted. Thanks a lot, Helena

Hi - I have been using Access off and on over many years, and currently am creating a database that is using a lot of forms. I haven't done a lot with forms for others in the past, so I have a lot of questions! I am pretty comfortable with VBA. I have spent the last day or so reading threads...