I have a reservation application that I have obtained reservation data from an email message (daqta from which is entered into the tblWorking table). The...

I am trying to Create a table from DDL code. Upon running the query I get the error: Syntax error in CREATE TABLE statement. (Error 3290) Here is my code...

I have two tables say A and B, what I am trying to achieve with the query is just to display records that have the received field ticked in table A and the...

I would like to create a query where the user can input 2 or more parameters (part numbers), separated by comma and/or space and return information about...

In Access 2003. In a form I have a parameter to search for a word at a a time Like ..txtWords]&"*" which works well. .. In order to enter more than two...

I'm trying to open Two reports with one command button. But everytime I click the command button it goes to the report2. How can I open report1 click until I...

eeeetertsdfgetyegertergertergerterfgdsftegerger

Hi I have a fingerprint time attendance system running, with its software that uses a microsoft access db. it currently has a crosstab query that results as...

I am a real Novice to MS Access 2003. I am trying to create a query to populate a form to be used as a subform in another form. I have created the form that...

I'm trying to fill out some forms with fields from a query. The forms are built in MS Word. So far all I get is inserted lists into the form but the fields...

Hi…I attempted to do a Union Query with two crosstabs. I received an error “Characters found after end of SQL statement. I then read some posts but...

I inherited about ten databases, Year2001, Year2002, etc. These databases are not related, even though they have information about same ID's (For example, ID...

I have Word forms to send tailor for each client I mail to. The forms are requesting specific information regarding employees. To that end, I am providing...

I'm building an update query that will concatenate two fields and update the first field with the combination of the two fields. However, I would like to...

Hello, I'm hoping this should be easy - I just can't seem to find the answer. I'm guessing my syntax is wrong but I can not figure it out. I am making a Db for...

I saw a post that showed how to convert from a number value to a string value. But how about the other way ? Convert a string value to a number...

Hi! Say you have a table A with fields field1, field2, field3 and field4 and I want to shift values so field1 receives the value from field2, field2...

Hello all, First off I want to say I read a lot of the previous posts about this issue and none seem to be similar to mine. I am working on a database...

Hi everyone, I've been helped out on here and managed to get a query working exactly how I wanted although now I can't seem to generate a chart from said...

Greetings, I'm going to confess right up front that I'm an Access noob, so there is a great possibility that what I'm asking is basic and that I just don't...