I am using access 97 at work. I am using a form to enter report criteria. In the report I have specified field 1 or 2 or 3 to select the data. That all works...

Hello, I just used the startup feature for an access database file, and set the file to not display the database (the table does not show being opened) :...

I created application for comunicating with Hitachi902 device for blood anylze. For each day database must be empty, and results from day before have to be...

I'm trying to query a set of data and I'd like to use a form. I have 16 check boxes... three different shifts on 5 weekdays and an "any" box. I'd like the...

I am trying to select fields from two tables and Union them into a table, but it seems I cannot do a 'select into ...', but I can create a recordset of...

Hi All, I am trying to build a query that will allow me to show any records past there end date. Each record has a start date and an end date and i need to...

I have 62 queries is there a way to make a form or dialog box so i can change the 1 and only difference in the queries What i mean is ? the queries are for...

I have an append query that requires the definition of two "parameters" as it executes. The problem is that each time I run it I have to manually enter the...

I am trying to link 9 tables that have a common field titled Physician Name. Each table has 4 categories that have a yes or no option. I want to link all of...

Good afternoon, I'm trying to pull over an ID from a primary table into a foreign field. I've put this syntax into the criteria of the query, but it's not...

Hi, How do you use two different date types in a query? For example, one table has a date stored as 'dd/mm/yy' but a second table holds only 'yyyy' I am...

Hello everyone. I am using an OBDC relational database, so the tables are already pre-built. I need to create a query(ies) for mailing(s) were certain people...

Every time I try to do a maketable query I get an invalid argument. This is very frustrating, and I do not understand why it is happening. Any ideas on how...

How can you get an Access CrosstabQuery to advise zero values in the total column?

Hello, I am running Access 2000. I would like to create a query in my date field that will show all records that are more than 45 days old. In other words if...

i have two columns in a query: Column One - Names Column Two - Dates Now I have multiples names and there are multiple dates for each individual. My question...

My question is this - when you have a crosstab query, with a count as the value, and there is no vaules in the data, so the field is blank in the output, what...

Hello, I have been concatenating fields in forms without a problem. But... when I do it with fields that are pulldowns, I get #Error. Perhaps someone has a...

I am trying to develop a cross tab query - the first time I tried it, I got a column with the . I used the NZ function as the column name - NZ(,"new...

I have employee numbers that are supposed to be 6 digit. So I am converting them to text, but when I do a number like 12345 is not 6 digit. I want to convert...