I set up a query in Access with a where block of: Model Like "*470*". It runs successfully. I embedded the same code in a web page and it does not pull...

i have this table : ID Course Detail1 Detail2 Detail3 St_1 Curse1 1 2 3 St_1 Curse2 1 2 3 St_1 Curse3 1 2 ...

Hello, I am trying to make the DSum work for me, but I am not an expert. I have read many posts and still cannot get the DSum to show what I want. I have a...

Hi, Is it possible to do the following? I've got a table, called 'Cases' and a table called 'Users' Within these tables are numerous fields, however what I...

Have you tried opening the databases with someone else's computer? -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager -...

I have a database with 3 instances of the same field for 3 different records ('Unit Cost'). I want to run a query to show the final cost but I need to add...

Hi, I am trying to sort some data in a report. What I am trying to do is for exemple, I have these datas: 10056, 10048, 10071, 10025 I want to sort in...

I am trying to create a query containing specific information. Let me explain... I have the following tables: Checkout Table contains the following...

Hello everyone: I have a 97 MS Access issue, I need to get resolve. A salesperson goes one store and spent few minutes for try to sale products and then leave...

Greetings, I have a table that contains events that have a start date/time and end date/time. I would like to calculate durations broken out by hour. So...

Ned help with allen browns popup calendar http://allenbrowne.com/ser-51.html I want to show monday as first weekday, and change color. In allen website there...

Hello: I have a form with two date fields (DateModified and DateModified2), each populated with "=Now()" on the click of buttons that trigger other events...

I have a form with an option group. Allocated, Unallocated, all In the table/query I have a corresponding field with either Allocated=1 or Unallocated=2. I...

This is almost perfect. It works on Table B beautifully, but when I do the join to Table A with the hopes of getting showing the other fields I get no...

Hello all, I would like to create a query that will return the (i) field names, (ii) "data type" and (iii) "description" on any given table (as one can see...

Each server name I want to be part of the results is now showing a record for each location. I need it to show only the location that belongs to the server...

I just needed to add the other table and not put a join and everything worked perfectly. Thanks you! "Colleen" wrote: I have two tables -- Table A -...

"KARL DEWEY" wrote: First create a select query like this -- SELECT IIF( Is NULL, , ) AS SiteCode, SiteName, SiteAddress FROM Then join on...

I have a combo box that displays the numbers 0-3. All of these numbers are linked to only one query within the rowsouce that displays a specific table. I am...

I am trying to make a template with a list of questions. The answers are scores ranging from 0-4, with an option of N/A (not applicable). The users of the...