query design

Hello, I'm trying to do a simple web query for a couple of sites, but however their tables are coded, it only queries the first page of the table rather than all results. When clicking to the next page of the table (or selecting to view all rows), the page URL doesn't change, which eliminates a...

Hi, I'm still learning access and I'm having some trouble with a database I am trying to make. Below is a photo of the relationships I generated for the proposed invoicing system called Direct Pay Voucher ("DPV"). Here is the set up: Many employees can generate a DPV (we want to track who...

Working with databases is new to me so thank you for any assistance you can provide. I have a database where data is stored as follows: Table: Rates <tbody> Company<o:p></o:p> Item<o:p></o:p> Labor Rate<o:p></o:p> Matl Rate<o:p></o:p> AAA<o:p></o:p>...

I want to create a query that calculates daily investment returns. The formula would be Market Value today divided by Market Value yesterday. Where I'm struggling is how to tell access to grab the market value from yesterday. My current TotalMarketValue query looks like this: <tbody> TotalMV...

I am looking to exclude a specific item from my query that is based on multiple fields. For example if I have a database of cars, greatly larger than shown below: Make | Color Ford | Red Toyota | Blue Chevy | Green Ford | Black I can't get Access to exclude only red and blue Fords. My...

I have a workbook with several tabs. One tab is called master. I then have another tab called summary sheet. On the summary sheet i have several tables which are all queries looking into the master tab. This is all on one computer and works fine. however if i want to put it on a usb the...

I am trying to automate the process of retrieving data for a bill of materials. My workbook is organized with the clean bill of materials on sheet1, titled BOM. On sheet2, I have formulas to extract the information from sheet1 and generate the URL for each part. I recorded a macro to perform...

Hello, I am currently working with a large data set of names, dates, rates, positions and effectivness. My data is in table format, and ranges circa 100 by 200 in size. I would like to have, within the same workbook, a connection to a second table, one which will update with any added rows...

I have a table that kind of looks like the one below. Over the top is departments and the rows are different items each department may need. The "X" indicates that department is in need of that items. Sales Marketing Finance Etc. Paper...

I am trying to use MS Access to query an MS Access database that is not the current database. I am using: <code style="margin: 0px; padding: 0px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera...

Good morning, I have three tables I need to bring together to make one. I am having problems joining two of the tables to get the results I need. The only way around my problem that I see is to create a seperate table from these and join it to my first table. I have a table that contains...

I am having an issue with my charts returning higher results than the query I am running them from. I have a query that counts the top ten items used in the last year. I am trying to create a subform or subreport for each chart I need so I can add it to a larger form or report. The problem is...

I am new to Access and want to covert my database over from Excel where I am very confortable to Access. I have a problem with several fields in my tables though. I need to search one column of data and replace it with the correct data. Example: Column Depot has several misspellings that I need...

I have a query that I run every month that gives me all the claims for a list of policies. I would like to export that list to excel where each policy would have it's own page with its list of claims. How would I construct this?

I am given a spreadsheet with a column of item numbers that changes each week. I need to take those item numbers and compare them to the same data in another database. I can connect to the database AS400(DB2) fine and return single rows of data. Rather than using the three options from the query...

So I have a very strange problem here. I am not the original developer of the database that I'm working on but am debugging certain problems. During this process I am trying to trace back certain fields. Here's the problem: I'm in the query design of "query1" which uses "query2". When I go...