1
  • Query for records that have certain numbers in them

    I have a table with 4 fields and 100 records(rows), with numbers in each field. Example would be: In Record One Fieldone has 87 fieldtwo has 94 fieldthree has 32 fieldfour has 99. than Record two has numbers in each field: Fieldone-94, Fieldtwo-33, Fieldthree-102, Fieldfour-44. I need to create a...

    Dnsnb25 pointsBadges:
  • Query for a Mail Merge

    When I access my Auction Query in Access I can pull it up and everyone is there. When I try to do a mail merge and pull up my auction query all the other queries are there except the auction query.

    4hcandles5 pointsBadges:
  • max query expression

    have a very basic table: dwg, dwg rev, rev date - what query expression do I write to show only highest rev?

    Mwatters5 pointsBadges:
  • Viewing the guts of a Microsoft Access form, query and report, programmatically

    I have over 1000 MDB's which need to be checked to make sure they don't reference any external sources. So, I'm searching for 'A:', 'B:'... 'Z:', '\', etc. I need to search the guts of each form, query definitions, and reports to find any references to something external. The data is done. Is there...

    DMoseley5 pointsBadges:
  • Microsoft Access QueryDef problem with numeric column anme

    I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in the query and could not. IF I...

    Davisdo5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following