I have data from a large spreadsheet and inherently, sections of the data are duplicated to fulfill requirements in the spreadsheet (like names, projects,...

If I am in design view either creating a query or editing the design, sometimes I want to test before saving. Is there a funtion key that I can use to Run...

I am trying to create a report that will allow a cross tab query to display different column headings depending on a parameter chosen by the user example...

The 101 ROMANTIC SECRETS and TECHNICS This SECRETS and TECHNICS are right for you if: 1. How to try to get a person you want, 2. To make your partner love...

Hi, I was wondering if there was a way to update several fields in a table using one update query. Basically, I would like to update 10 fields in tblA to...

The story so far: Parent Table SalesOrders having primary Key SFSOID, and a couple of child tables (One to many) Receivables which stores the SFSOID in a...

In the query i designed i have duplicate units but with unique work order numbers, so they are not duplicate records, however i want to show only the record...

Hi, I have a main form and a sub form (they are NOT linked). However, on the main form I have 4 buttons which I would like to use as a filtering for the sub...

Sorry about the generic subject line but couldn't come up with short description :O. A table has some records such as. Account Rep Division A ...

I have an overtime database in which once a year I need to roll back overtime hours by the lowest employees' total. I have an overtime code to calculate...

I have four different types of salesmen, SVP VP SC and EA. For each sale that is recorded, any combination of these types of salesmen can be entered in....

We use a database for employees to enter the time they spend each day on a particular project. Currently, I have a crosstab query set up to give me a report...

I have a report run by MainQuery. When I click on the main query it is queried my LeaseName. I type in Cromer #10 and everything comes up. I type Franks 19 #1...

I am building a warehouse management database from the ground up. The problem I am running into involves the 'location'. Problem #1- I have an "Upcoming...

My table contains a text field called "Company_Name". As the name idicates it holds a text value of a name however, it contains names that may be the same...

I have a query that selects about 10 fields, one of which is called CODE. The value I'm looking for is where code = AAAA. (this is an example..) I get a...

i want to view report based on employee ID and by year selected. I created report depend on table query. what commad/SQL command for view employee by...

I have a crosstab query that uses the between (two dates) function. The query works fine but when I try to create a report out of it it says that the row...

Hi all, I need to scrub some data prior to shipping it off to a vendor for them to debug their code. I want to update all the rows in the table with the...