Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

access

ResolvedVersion 2000

Anna has attended:
Access Intermediate course

Access

I am using Access 2000. I have set parameter queries requesting date ranges on a couple of my queries, but often it asks for both start and end date more than once. It doesn't look like there is any duplication in design view. Any ideas what could be causing this please?

RE: Access

Hi Anna

Sorry for the delay.

If you could send me a screen shot of the query

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.