I have a query that has multiple yes/no fields. Can I run a form to enter a parameter into one of the fields and then run the query?

This seems it should be simple, but here is an example and question. Sample data: Name Response# ------- ---------------- Jane 2 Jane ...

I need to run a query that run from multiple yes/no boxes on a form. I have set the form up with the required fields and have place the following into the...

Hello - I have a table which I called Reference: Exceptions. It is composed of two fields: FieldName FieldValue I would like to use this table to use in...

I have several fields that I need to sum by type and week for multiple weeks (more than a year-nearer to 2). This is an attempt to take a VAST amount of...

I have a query that I have been asked to create that is very foreign to me and I would almost think to be impossible. However, I throw this out here to...

I have a couple of questions but I think they are related. I have a query that I am trying to export to Excel without formatting. However, everytime I try...

This is a hard one. I have been struggling for a while PLEASE PLEASE HELP I have a query that has two fields admission date and discharge date. I have a...

I receive a compile error message when using this function. What should I do. Range: DateAdd('d',5,!) Thank you, Melody

The following query works fine in 2003, but gives me data type mismatch errors in 2007. There are 241 records that have 0s when I run the select portion of...

I have a table that I need to populate the missing data with the data field preceding it. Can I do this with a query?

Hi, I'm new to Access. I set up a database consisting of a master ID table with details about each ID, and several other tables which are also indexed by the...

I am currently working with a database which has basins, streams, and years. There are other things as well, but these are what I am concerned with. I need...

Hello, I have separate queries that display the sum of: Total Credits, Bad Credits, and Closed credits. I am creating a new query(to put everything together)...

I have seen such a query but can’t build one, tried to do it myself but I’m missing something. I have a table tblEmployees and would want to create a...

Thanks for any help. I am trying to change the date (to one day less of the second repeated record) of a field in about 120 repeated records (repeating in two...

This is a pretty straightforward query (I'm sure) but I have no knowledge of Access, so I can't figure it out. I have 1 table, and need to delete duplicates,...

I’m trying to run an up date query, if the checkbox is True then un-check it. If the checkbox is false then check it. UPDATE tbDetails SET...

Basically I have access to a bunch of tables that are created once a day. What I want is to have a box where I input the name of the desired table and then...

Hi I got 3 related tables: Quotehead, Quotedetails and QuoteItems : I want to make a Distinct list of all rows from Quoteitems column "Description" and in...