I am quite new to Access and I am wanting to create a follow-up program for my customers that will give me a detailed report of my customers that I sold 3...

I have a table that i want to query on to create a form. Here is the criteria and I don't know how to do it. There is an ID which is an autonum,...

Hi all, i design and execute a SQL SCRIPT to create tables in ACCESS ( create table, add constraints, etc... ) All is alright for fields names and types,...

Hi, I created a qry Basically the an ID could have many groups like this ID Groups 17 A 17 B 17 C

What I want to do: "select id from querywithparameters" Now how do I tell Access that he needs to transfer the parameter values of a, b & c to...

Hi, I have data that I would like to summarize by site, but unfortunately the parameters I am summarizing for occur across columns, because the data is...

Hello, I have a single table with the following fields: CLASS CATEGORY READDIFF CODE DATE

OK, this is probably ridiculously obvious, but I've been staring at this query for too long and it stopped making sense. I think I just need a fresh pair of...

Hi, I have a table MyTable that has a unique index on a field called LineNo. Let's say my table has 6 records with the following values for LineNo: 1, 2,...

I have a query (two fields - one sale type, one lot #) in which the lot is set to count. The current query I have displays the information as zero if there...

Hi, I have a report in which I have put in a date range, the code is below Option Compare Database Private Sub Command4_Click() Dim strReport As String ...

1. we have a query where we're calculating a pct and format the column as pct. 2. the criteria for the column is asking for .. 3. The results are giving us...

i am new to access, and learning as i go along. well, specifically, i'm new to making a database, rather than just using one. first only have need one...

Hello all, I have come a cross a problem; while using the 'append query' to write data from a old table into a new table, I found that the memo field used in...

I have 4 normalized tables which when queried produce a orderd flow for the production of one of many ( 1000's ) of my companies products. What I get is...

I am creating a table by importing a csv file. This field is not importing correctly - Error / Type Conversion Failure. Here's the data before...

Hello all, I found something I did not expect, while using the below query i found that all records end up with the same number. UPDATE tblNewFAQ SET...

Hi all, I have this SQL code that will Append some record from one table to another, from tblPrices to a table with a name defined by the SessionID of the...

To All: I desperately need helps on the following : I am trying to combine records from a make table query result (Table A) shown in the example below: Id#...

I have a field on a form that I would like to make some type of Quick Code for. Example: Instead of typing out Missouri I would like the users to be able...