I am creating a crosstab query where the heading is a date value (i
have the format in MMM), the row is a text and the values are numbers.
I am hvaing trouble creating a YTD column which differs from a total.
If i set my criteria at a month, the total column gives me totals for

We have a timekeeping system in FoxPro and I linked to it with Access to be
able to view schedules, make reports, etc without having to pay for every
custom report we need.  I set up this query below to pull up schedules by
employee:

I have two tables. I have a furniture table [Item number] and a fabric
table[FabricSpecs]. The furniture table has three fabric fields [Item
number.FabricSpec] [FabricSpec2] [FabricSpec3] (yes, the names are
confusingly similar). Each of the fabric fields in the [Item number] ...

I'm new to working with Access,  so bear with me.  I've created a database
where I need to make a Query Parameter Form.   I have the form set up and am
close to getting it to work.  Anyway, here’s my SQL Statement:
SELECT Main, Submenu, Pictures

I have a need to generate a report showing a 10% Random selection of
records. There will be an initial criteria of a date, then I need to have a
random selection of 10% of the selected records displayed on the form.
Is the 10% part achievable and the random part also achievable, ...

Howdy!
I usually prefer Visual FoxPro, so Access isn't really my thing, and I can't
seem to find a good example of a SQL query in Access's syntax.
What I'm attempting to do is take data from fields in the current record (in

I have 2 tables (table1 & table2) in query that don't have a relational field
each other. Table1 has Date, decription & amount. Table2 has RecordNo &
filenm. I'd like to pull all fields in Table1 and only the last record of
field Filenm in table2.

Hello i am trying to create an update query......FROM: another query which is
not editable and is product of another Union query.......TO: a newly made
table. i get an error that the update query is too complex can anyone help
with that, my query is posted bellow.

Hello all, hope everyone is doing well this fine morning!
I need some help in constructing a query.  I have three tables,
designed as so:
Personnel

I have created a form to query some information. I have 4 different
columns that I use and change criteria of by using drop down lists in
a form.
ALL of them work fine except for SVP and I don't know why. The SVP

I'm trying to determine if a unique string of data from one field exists in
another field. For example, the first column might have the values 12345, and
the second column might have the values ABC12345 or 12345ABC or AB12345C, etc.
The starting point of the matching string is ...

Having Build a query using the Query design, how can I run this query within
VB. Does anybody know the syntax to do this

When using the expression builder in Access to create a calculated field,
what does the "Value" section mean?  It's the in the third column in the
expression builder.
Thanks!

Folks,
I have a database table that includes a list of dates (weekdays only).  I
built a query that returns unique dates only.  I now want to add a second
field that numbers the dates with the most recent date being 1, the day

I have created a Pivot Table of employee data, with each day of the month
showing the hours the employee worked and what type of hours they are
(Production, Non-Production, Holiday, vac, etc). What I want to do is break
out the weekly totals, but my week begins on Thursday. Help!