I have created the query and it works but does not "fill" until the query is closed and reopened. I want it to "fill" immediately when I tab to the next...

I need some help on how to get the info I'm looking for. TblGift ID(primary key) DonorID GDate (contains all gift dates for donors) GAmount (contains...

I hope someone has an idea how I can accomplish this I have created a monthly audit report for workers compensation, which looks at the week ending date of...

i have an update query and i want to update a lookup field. how can i select the data/value instead of typing it? because if i type it the value does not...

I have a table with a list of data. How do I use a query (and perhaps and expression builder) to give me the averages of a number of points of data. So say I...

I have a query set up to count totals of visits for different hospitals within a given time frame. I want it to list all hospitals regardless of if they had...

Every week, I must import an excel file into Access in order to create a .txt file that we then load into our AS400. Is there a way to save the initial...

Dear Group. I have a table with - among other things - names and salaries. My problem is to return the TWO highest salaries: Name ...

After I run a Make Table query I would like to then add an additional field in the table. How can I automatically create a new field in a table. My table...

I am trying to convert the SQL code from an append query to a DoCmd.RunSQL statement. I have the SQL for it below. For some reason, I cannot get all of this...

I have an equipment repair table called Repair_History. Each row represents a work order for a particular piece of equipment. Each row has several columns...

I have a table where each time a patient is seen we find out what hospital they originally came from. This is entered for each person on the date they arrive....

I have a querry with the following (example) number of cards(A) amount per card (B) total amount ( A*B) Both B and A*B are formated as 2 decimal places I...

Hi, I am building queries for duplicate payments reports. The query works ok and comes up with the correct detail but when I go to run it in the report I get...

I need help I am not sure how to this. I have created a table. That has student information. This table is a listing of students that are registered for a...

I have a one-to-many relationship table (a Board has many members). Member positions can be a) Chairman, b) Secretary, or c) Member. I need to create a query...

I have a table of several hundred customers and I want to run a query/report that shows me in what DMA Market these people are in. I have a list that I can...

I've taken on the unfortunate task of updating an existing query to include another table in a left join. unfortunately, I'm getting this error: Join...

I have a database with "Disease" as a field. Entries include things like Salmonella, E.coli, Hepatitis A... I would like to count the total number of each...

My query returns: OpenDate, CloseDate, DaysOpen with iif(NZ(T.CloseDate,"")="",Now() - T.OpenDate,T.CloseDate - T.OpenDate) AS DaysOpen It seems to work when...