I am wanting to do a search that will show me records within a specific time frame. I have it set up now to enter a Pay Period Start Date and End date but I...

Hello all - I'm hitting a SQL backend database that has a time field in it, but it's store as numbers. Below is some of the data it contains: Entered ...

I'm trying to install bluetooth usb adapter but this error is occuring on my computer: "This problem was caused by a compatibility issue between...

Hello All, I have a query in which I use a function to calculate the quantity that needs to be ordered based on the stock and the demands of a customer. The...

I'm trying to do a passthru query using two tables to just pull patient diagnosis code from one table and the diagnosis description from another. When I run...

Hope someone can help me with this as, despite spending a lot of time looking through previous posts, I'm still no wiser. I have a table to log incoming...

running access 2k; the mdb I'm using has no local tables - all are link to a back-end mdb, and a sql-server. I'm trying to run a find duplicates query, but...

I am a novice at Access and I have created a query to total statistical information, I know how to create totals within a record, but I need to total like...

I amy trying to create an Update query to change the data type from numeric to text. i.e.: Field. is 1 and I want it to update the table with...

I need criteria for a date field in my query. I want only the dates returned that are older than 5 business days. Thanks! -- Message posted via...

Is there a way to find all of the queries that use a specific table? I have a table with names and codes for each name. My company has changed all of the...

I keep getting the "can't delete from specified tables" message. I've tried using the totals query as it is, as well as using a table composed of the records...

Hi guys, I would like to know if this is possible. I have a price column, in my query I return this as a total row, so it shows the totals for each item I...

I have a names & addresses database set up with an auto-numbering reference field at the beginning. (Access 2002) Today I tried to merge in same new records...

I am also experiencing this. I get the date from and Unjoined Table that only has a single record which is system generated. Perhaps you can guide me as...

Good morning, I have a quick question, I have this database that has all of our tracking information for about 30 locations based on 10 procedures. We then...

I have a table that has been sent to me that has multiple time stamps done when individuals update the fields. I need to find the min of 6 date fields. can...

I want to print a form and its contents , In the past i've use Docmd.Printout to send the form to the printer this has worked well in the past. Now I want to...

Hi everyone, I have a table laid out as follows: Record# ID DATA 1 1 LIS 2 1 LIS 3 1 (Blank) 4 ...

How can you retrieve the latest 10 records of, for example, 5670 records within a database? Where rowcount10 ?? Oracle isn't it? Thanks in advance.