This is what the Query code is and this is what I would like to added to it......Thanks Bob SELECT tblHorseInfo.HorseID,...

Here is a query that we had discussed a while back. I would like to know if someone can adapt the SQL Aggregate Value query expression to additionally...

I am very new using access. I have put together a small inventory database. I have a items table, disbursement table and receiving table. I want to pull...

This sounds simple but I'm coming up blank. table one: tblStaff StaffID Name Dept table two: tblTimesheets StaffID Date

Hi, there. I'm using Access 2002. I've made a form based parameter query using the same help column (...

I have designed the following query in the Access query design grid. It deletes a record from a table with two fields. When I preview the query results 4...

I have a table with patient accounts, dates, and procedure codes. I want to run a query that looks for a certain procedure code (that part is easy), but when...

I set up a database with two tables and did a query covering both tables. I also set up a form to populate the two tables. When I go back to the query to...

hello everyone my boss gave me an excel file which contain a list of addresses for hospitals and doctos the first column is a serial number , which is a...

Hi all, query solution I hope ! I have imported a csv address file into access : Address1 Address2 - Address6 Some fields are blank followed by another...

Hi all, I am trying to get query to return record like follow: name 123 mian st. houston, tx 77082 USA but the result i get is as followed:

My mailing list often has two last names for a given address. Each is a separate row in my database. I want to be able to make an address label that says...

Okay I have a table with just addresses and a idaddy unique to each record. I have another table with name and other personal info and a client id that is the...

I want to insert a comma after in the address string in my query. Expr1: & " " & & " " & . HELP!

Hallo, I have a main Report that contains the subreport rsubEmployee. On opening the main report the form fdlgEmployee is loades to make a date selection....

Hello, I'm trying to figure out a way to populate an address table with the linking ID of a region table. Here are the specifics: tblLeads contains address...

I am trying to create a query that will add 1 day to date field. Shift is from 11 pm to 7 am. I have a date/time field that needs to be adjusted. If time is...

I have a database that collects time stamps of material movement through a certain area. It's great for collecting metrics. This initial loading of data,...

Hi All, I've progressed a filter in a query of mine TODAY CHARGES to lookup up records according to the following SQL: SELECT RUNDATE.DATE,...

My query in SQL looks like the following: SELECT Sum(Journal.Amount) AS SumOfAmount, Sum(+) AS RentIncome FROM Rent INNER JOIN Journal ON Rent.Tenant =...