Hi...I'm new to Access.. Using the query design view, how do update a date field that is in mm/dd/yyyy format to yyyymmdd? Thank you!

I am attempting to create a crosstab query that would give me an output like this: event_id top_depth_zooplankton Species1 Species2 ...

I have 4 fields in my table, Item, Length, Width, & Height. For any item the length is not always the largest dimension, sometimes it could be height or...

Hi! I'm attempting to do a "matched" Query instead of an unmatched. I want Access to compare two tables of data that I have and tell me which records are...

need help with the syntax for an update query to update a blank field named PayCode (created because of the way the source financials are) in my access...

I have a report that is based off a query that is set as a template to print. How do I get it to not leave a blank page between records? Thank you

I am trying to merge 3 fields but also add spaces and comma. This is what I am using & ( "," )&" " (" " & ) & (" " & ) I would like it to read New York,...

The following statement is still not working. A couple of questions: 1) Is my tablename suppose to be in brackets? 2) Is the suppose to be my...

Hi, I'd like to know which condition in where part of sql will be considered first. I'd like to optimize sqls. For example: select * from table t where...

I have a Cross Tab Query that uses a linked TXT file for data. The file contains mostly numbers, but they are formated as Text. The file comes from a server,...

I would like to know whether there is a way I can calculate the interest amount based on average daily balance and how I can calculate the average daily...

i want to get all constraints name, its type which was defined in my database. is there any query to find out .

below is my example tables: issuance_table: transaction_table: item condition qty. ...

I would like to display data obatianed from a query in a String rather than in Rows, any ideas? eg qry displays Record1 Record2 ....

How do I convert a column label number to a column label text in a crosstab query value field?

Hello, I have form which has a hostname (textbox) plus several additional fields. I would like to validate that the hostname entered by the user already...

The following doesn't seem to be working. It seems to get the computer bogged down. Is there another solution to this? or can someone show me how to do this...

Please suggest a query to remove multiple symbols (, . #) from a field. I was able to use the Replace function to remove one symbol and not multiple. Ex:...

Hi everyone! Using A02 on XP. I get an extract from systems each week with data that we use Access to analyze. Of 4 date fields in my Access import table,...

Hello, I thought this would be straightforward, but I'm coming up with errors that I can't resolve yet. I would like to filter based on a calculation using...